How is Zabbix events related to hosts in the database?

Question

Zabbix

Hello.
There was a desire to create your own custom report on zabbix events in detail by hosts.
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 related to zabbix.hosts?
I suspect that it is possible through objectid, but how ...