Table "public.hosts" Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description --------------------+-------------------------+-----------+----------+-----------------------+----------+-------------+--------------+------------- hostid | bigint | | not null | | plain | | | proxy_hostid | bigint | | | | plain | | | host | character varying(128) | | not null | ''::character varying | extended | | | status | integer | | not null | 0 | plain | | | ipmi_authtype | integer | | not null | '-1'::integer | plain | | | ipmi_privilege | integer | | not null | 2 | plain | | | ipmi_username | character varying(16) | | not null | ''::character varying | extended | | | ipmi_password | character varying(20) | | not null | ''::character varying | extended | | | maintenanceid | bigint | | | | plain | | | maintenance_status | integer | | not null | 0 | plain | | | maintenance_type | integer | | not null | 0 | plain | | | maintenance_from | integer | | not null | 0 | plain | | | name | character varying(128) | | not null | ''::character varying | extended | | | flags | integer | | not null | 0 | plain | | | templateid | bigint | | | | plain | | | description | text | | not null | ''::text | extended | | | tls_connect | integer | | not null | 1 | plain | | | tls_accept | integer | | not null | 1 | plain | | | tls_issuer | character varying(1024) | | not null | ''::character varying | extended | | | tls_subject | character varying(1024) | | not null | ''::character varying | extended | | | tls_psk_identity | character varying(128) | | not null | ''::character varying | extended | | | tls_psk | character varying(512) | | not null | ''::character varying | extended | | | proxy_address | character varying(255) | | not null | ''::character varying | extended | | | auto_compress | integer | | not null | 1 | plain | | | discover | integer | | not null | 0 | plain | | | custom_interfaces | integer | | not null | 0 | plain | | | uuid | character varying(32) | | not null | ''::character varying | extended | | | Indexes: "hosts_pkey" PRIMARY KEY, btree (hostid) "hosts_1" btree (host) "hosts_2" btree (status) "hosts_3" btree (proxy_hostid) "hosts_4" btree (name) "hosts_5" btree (maintenanceid) Foreign-key constraints: "c_hosts_1" FOREIGN KEY (proxy_hostid) REFERENCES hosts(hostid) "c_hosts_2" FOREIGN KEY (maintenanceid) REFERENCES maintenances(maintenanceid) "c_hosts_3" FOREIGN KEY (templateid) REFERENCES hosts(hostid) Referenced by: TABLE "autoreg_host" CONSTRAINT "c_autoreg_host_1" FOREIGN KEY (proxy_hostid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "dashboard" CONSTRAINT "c_dashboard_2" FOREIGN KEY (templateid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "drules" CONSTRAINT "c_drules_1" FOREIGN KEY (proxy_hostid) REFERENCES hosts(hostid) TABLE "group_prototype" CONSTRAINT "c_group_prototype_1" FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "host_discovery" CONSTRAINT "c_host_discovery_1" FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "host_discovery" CONSTRAINT "c_host_discovery_2" FOREIGN KEY (parent_hostid) REFERENCES hosts(hostid) TABLE "host_inventory" CONSTRAINT "c_host_inventory_1" FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "host_rtdata" CONSTRAINT "c_host_rtdata_1" FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "host_tag" CONSTRAINT "c_host_tag_1" FOREIGN KEY (hostid) REFERENCES hosts(hostid) TABLE "hostmacro" CONSTRAINT "c_hostmacro_1" FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "hosts" CONSTRAINT "c_hosts_1" FOREIGN KEY (proxy_hostid) REFERENCES hosts(hostid) TABLE "hosts" CONSTRAINT "c_hosts_3" FOREIGN KEY (templateid) REFERENCES hosts(hostid) TABLE "hosts_groups" CONSTRAINT "c_hosts_groups_1" FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "hosts_templates" CONSTRAINT "c_hosts_templates_1" FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "hosts_templates" CONSTRAINT "c_hosts_templates_2" FOREIGN KEY (templateid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "httptest" CONSTRAINT "c_httptest_2" FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "interface" CONSTRAINT "c_interface_1" FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "items" CONSTRAINT "c_items_1" FOREIGN KEY (hostid) REFERENCES hosts(hostid) TABLE "lld_override_optemplate" CONSTRAINT "c_lld_override_optemplate_2" FOREIGN KEY (templateid) REFERENCES hosts(hostid) TABLE "maintenances_hosts" CONSTRAINT "c_maintenances_hosts_2" FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "opcommand_hst" CONSTRAINT "c_opcommand_hst_2" FOREIGN KEY (hostid) REFERENCES hosts(hostid) TABLE "optemplate" CONSTRAINT "c_optemplate_2" FOREIGN KEY (templateid) REFERENCES hosts(hostid) TABLE "task" CONSTRAINT "c_task_1" FOREIGN KEY (proxy_hostid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "valuemap" CONSTRAINT "c_valuemap_1" FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE TABLE "widget_field" CONSTRAINT "c_widget_field_3" FOREIGN KEY (value_hostid) REFERENCES hosts(hostid) ON DELETE CASCADE Triggers: hosts_delete BEFORE DELETE ON hosts FOR EACH ROW EXECUTE FUNCTION changelog_hosts_delete() hosts_insert AFTER INSERT ON hosts FOR EACH ROW EXECUTE FUNCTION changelog_hosts_insert() hosts_name_upper_insert AFTER INSERT ON hosts FOR EACH ROW EXECUTE FUNCTION hosts_name_upper_upper() hosts_name_upper_update AFTER UPDATE OF name ON hosts FOR EACH ROW EXECUTE FUNCTION hosts_name_upper_upper() hosts_update AFTER UPDATE ON hosts FOR EACH ROW EXECUTE FUNCTION changelog_hosts_update() Access method: heap List of relations Schema | Name | Type | Owner | Persistence | Access method | Size | Description --------+-------+-------+--------+-------------+---------------+-------+------------- public | hosts | table | zabbix | permanent | heap | 16 kB | (1 row)