Q:

Zabbix DB: how events linked to hosts

I want to create the custom report on event by 2 monitoring system. 
I know about Zabbix API, but think 
if I request data through the API, then the performance will not be the same if I perform queries directly to the database Zabbix. 
I found a table with information about events,
SELECT eventid, source, object, objectid, clock, value, acknowledged, ns
FROM zabbix.events

Found zabbix.hosts and zabbix.host_inventory. 
How is zabbix.events linked to zabbix.hosts? 

A:

objectid for trigger events (source=0) is the trigger ID, which in turn has function IDs, which in turn have item IDs, which in turn have host IDs.