Table "public.items"
        Column         |          Type           | Collation | Nullable |          Default          
-----------------------+-------------------------+-----------+----------+---------------------------
 itemid                | bigint                  |           | not null | 
 type                  | integer                 |           | not null | 0
 snmp_community        | character varying(64)   |           | not null | ''::character varying
 snmp_oid              | character varying(512)  |           | not null | ''::character varying
 hostid                | bigint                  |           | not null | 
 name                  | character varying(255)  |           | not null | ''::character varying
 key_                  | character varying(255)  |           | not null | ''::character varying
 delay                 | character varying(1024) |           | not null | '0'::character varying
 history               | character varying(255)  |           | not null | '90d'::character varying
 trends                | character varying(255)  |           | not null | '365d'::character varying
 status                | integer                 |           | not null | 0
 value_type            | integer                 |           | not null | 0
 trapper_hosts         | character varying(255)  |           | not null | ''::character varying
 units                 | character varying(255)  |           | not null | ''::character varying
 snmpv3_securityname   | character varying(64)   |           | not null | ''::character varying
 snmpv3_securitylevel  | integer                 |           | not null | 0
 snmpv3_authpassphrase | character varying(64)   |           | not null | ''::character varying
 snmpv3_privpassphrase | character varying(64)   |           | not null | ''::character varying
 formula               | character varying(255)  |           | not null | ''::character varying
 error                 | character varying(2048) |           | not null | ''::character varying
 lastlogsize           | numeric(20,0)           |           | not null | (0)::numeric
 logtimefmt            | character varying(64)   |           | not null | ''::character varying
 templateid            | bigint                  |           |          | 
 valuemapid            | bigint                  |           |          | 
 params                | text                    |           | not null | ''::text
 ipmi_sensor           | character varying(128)  |           | not null | ''::character varying
 authtype              | integer                 |           | not null | 0
 username              | character varying(64)   |           | not null | ''::character varying
 password              | character varying(64)   |           | not null | ''::character varying
 publickey             | character varying(64)   |           | not null | ''::character varying
 privatekey            | character varying(64)   |           | not null | ''::character varying
 mtime                 | integer                 |           | not null | 0
 flags                 | integer                 |           | not null | 0
 interfaceid           | bigint                  |           |          | 
 port                  | character varying(64)   |           | not null | ''::character varying
 description           | text                    |           | not null | ''::text
 inventory_link        | integer                 |           | not null | 0
 lifetime              | character varying(255)  |           | not null | '30d'::character varying
 snmpv3_authprotocol   | integer                 |           | not null | 0
 snmpv3_privprotocol   | integer                 |           | not null | 0
 state                 | integer                 |           | not null | 0
 snmpv3_contextname    | character varying(255)  |           | not null | ''::character varying
 evaltype              | integer                 |           | not null | 0
 jmx_endpoint          | character varying(255)  |           | not null | ''::character varying
 master_itemid         | bigint                  |           |          | 
 timeout               | character varying(255)  |           | not null | '3s'::character varying
 url                   | character varying(2048) |           | not null | ''::character varying
 query_fields          | character varying(2048) |           | not null | ''::character varying
 posts                 | text                    |           | not null | ''::text
 status_codes          | character varying(255)  |           | not null | '200'::character varying
 follow_redirects      | integer                 |           | not null | 1
 post_type             | integer                 |           | not null | 0
 http_proxy            | character varying(255)  |           | not null | ''::character varying
 headers               | text                    |           | not null | ''::text
 retrieve_mode         | integer                 |           | not null | 0
 request_method        | integer                 |           | not null | 0
 output_format         | integer                 |           | not null | 0
 ssl_cert_file         | character varying(255)  |           | not null | ''::character varying
 ssl_key_file          | character varying(255)  |           | not null | ''::character varying
 ssl_key_password      | character varying(64)   |           | not null | ''::character varying
 verify_peer           | integer                 |           | not null | 0
 verify_host           | integer                 |           | not null | 0
 allow_traps           | integer                 |           | not null | 0
Indexes:
    "items_pkey" PRIMARY KEY, btree (itemid)
    "items_1" UNIQUE, btree (hostid, key_)
    "items_3" btree (status)
    "items_4" btree (templateid)
    "items_5" btree (valuemapid)
    "items_6" btree (interfaceid)
    "items_7" btree (master_itemid)
Foreign-key constraints:
    "c_items_1" FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE
    "c_items_2" FOREIGN KEY (templateid) REFERENCES items(itemid) ON DELETE CASCADE
    "c_items_3" FOREIGN KEY (valuemapid) REFERENCES valuemaps(valuemapid)
    "c_items_4" FOREIGN KEY (interfaceid) REFERENCES interface(interfaceid)
    "c_items_5" FOREIGN KEY (master_itemid) REFERENCES items(itemid) ON DELETE CASCADE
Referenced by:
    TABLE "application_prototype" CONSTRAINT "c_application_prototype_1" FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE
    TABLE "functions" CONSTRAINT "c_functions_1" FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE
    TABLE "graphs" CONSTRAINT "c_graphs_2" FOREIGN KEY (ymin_itemid) REFERENCES items(itemid)
    TABLE "graphs" CONSTRAINT "c_graphs_3" FOREIGN KEY (ymax_itemid) REFERENCES items(itemid)
    TABLE "graphs_items" CONSTRAINT "c_graphs_items_2" FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE
    TABLE "host_discovery" CONSTRAINT "c_host_discovery_3" FOREIGN KEY (parent_itemid) REFERENCES items(itemid)
    TABLE "httpstepitem" CONSTRAINT "c_httpstepitem_2" FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE
    TABLE "httptestitem" CONSTRAINT "c_httptestitem_2" FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE
    TABLE "item_application_prototype" CONSTRAINT "c_item_application_prototype_2" FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE
    TABLE "item_condition" CONSTRAINT "c_item_condition_1" FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE
    TABLE "item_discovery" CONSTRAINT "c_item_discovery_1" FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE
    TABLE "item_discovery" CONSTRAINT "c_item_discovery_2" FOREIGN KEY (parent_itemid) REFERENCES items(itemid) ON DELETE CASCADE
    TABLE "item_preproc" CONSTRAINT "c_item_preproc_1" FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE
    TABLE "items" CONSTRAINT "c_items_2" FOREIGN KEY (templateid) REFERENCES items(itemid) ON DELETE CASCADE
    TABLE "items" CONSTRAINT "c_items_5" FOREIGN KEY (master_itemid) REFERENCES items(itemid) ON DELETE CASCADE
    TABLE "items_applications" CONSTRAINT "c_items_applications_2" FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE
    TABLE "lld_macro_path" CONSTRAINT "c_lld_macro_path_1" FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE
    TABLE "widget_field" CONSTRAINT "c_widget_field_4" FOREIGN KEY (value_itemid) REFERENCES items(itemid) ON DELETE CASCADE