Zabbix Database Relation Schema

[sauron]

I'm think this may useful.

[jherazob]

Is this still valid in recent versions (1.8+)?

A cursory look shows me that there's quite a few tables not shown there (11 in the diagram, 88 on the database), so i don't know if this was an intentional omission (only focus on the few that really matter) or if it's outdated (it's several years old after all)

[nelsonab]

:-) The original post was from 2006. A lot has changed since then.

[jherazob]

Is there a more recent one?

I've been looking and all i've found is this one, i suspect my search skills have failed me

[nelsonab]

They haven't failed you... it's just a somewhat daunting task to keep up to date. Ideally there should be a dot file from which a diagram can be generated.

[richlv]

note that it might be a bit easier in 2.0, as you can use foreign keys to auto-generate most of it and just finish the few remaining issues (like screen element ref ids)

[Fof]

:-) The original post was from 2006. A lot has changed since then.

Hi everybody,

I am trying to do a logical link between two tables in the database:
- users
- hosts

I have made a draft of the database structure but I cannot link the two tables above. Could you help me please ?

Thanks.

[Fof]

Hi everybody,

I am trying to do a logical link between two tables in the database:
- users
- hosts

I have made a draft of the database structure but I cannot link the two tables above. Could you help me please ?

Thanks.

Here is my current draft of my try to perfom a reverse engineering. Perhaps, it could help someone else to use the zabbix DB.

I am still trying to join the table "users" with the table "hosts"...

[opd0]

I would also be interested in understanding the database structure.

[heaje]

I am still trying to join the table "users" with the table "hosts"...

The "users" table won't join directly to the "hosts" table. Host/Hostgroup permissions are applied to user groups, not users directly.

[Fof]

The "users" table won't join directly to the "hosts" table. Host/Hostgroup permissions are applied to user groups, not users directly.

Thanks a lot.

Here is a dedicated post:

https://www.zabbix.com/forum/showthread.php?t=39011

[qix]

For anyone finding this thread looking for the schema, an updated version is now on the Wiki:

www.zabbix.org/wiki/Database_Schemas

[Fof]

For anyone finding this thread looking for the schema, an updated version is now on the Wiki:

www.zabbix.org/wiki/Database_Schemas

Thanks

[SRkr]

Is there a DB schema diagram or Entity Relationship diagram available for Zabbix 4.0?