<code>
+----------------------------+
| Tables_in_zabbix           |
+----------------------------+
| acknowledges               |
| actions                    |
| alerts                     |
| application_discovery      |
| application_prototype      |
| application_template       |
| applications               |
| auditlog                   |
| auditlog_details           |
| autoreg_host               |
| conditions                 |
| config                     |
| config_autoreg_tls         |
| corr_condition             |
| corr_condition_group       |
| corr_condition_tag         |
| corr_condition_tagpair     |
| corr_condition_tagvalue    |
| corr_operation             |
| correlation                |
| dashboard                  |
| dashboard_user             |
| dashboard_usrgrp           |
| dbversion                  |
| dchecks                    |
| dhosts                     |
| drules                     |
| dservices                  |
| escalations                |
| event_recovery             |
| event_suppress             |
| event_tag                  |
| events                     |
| expressions                |
| functions                  |
| globalmacro                |
| globalvars                 |
| graph_discovery            |
| graph_theme                |
| graphs                     |
| graphs_items               |
| group_discovery            |
| group_prototype            |
| history                    |
| history_log                |
| history_str                |
| history_text               |
| history_uint               |
| host_discovery             |
| host_inventory             |
| host_tag                   |
| hostmacro                  |
| hosts                      |
| hosts_groups               |
| hosts_templates            |
| housekeeper                |
| hstgrp                     |
| httpstep                   |
| httpstep_field             |
| httpstepitem               |
| httptest                   |
| httptest_field             |
| httptestitem               |
| icon_map                   |
| icon_mapping               |
| ids                        |
| images                     |
| interface                  |
| interface_discovery        |
| interface_snmp             |
| item_application_prototype |
| item_condition             |
| item_discovery             |
| item_parameter             |
| item_preproc               |
| item_rtdata                |
| items                      |
| items_applications         |
| lld_macro_path             |
| lld_override               |
| lld_override_condition     |
| lld_override_opdiscover    |
| lld_override_operation     |
| lld_override_ophistory     |
| lld_override_opinventory   |
| lld_override_opperiod      |
| lld_override_opseverity    |
| lld_override_opstatus      |
| lld_override_optag         |
| lld_override_optemplate    |
| lld_override_optrends      |
| maintenance_tag            |
| maintenances               |
| maintenances_groups        |
| maintenances_hosts         |
| maintenances_windows       |
| mappings                   |
| media                      |
| media_type                 |
| media_type_message         |
| media_type_param           |
| module                     |
| opcommand                  |
| opcommand_grp              |
| opcommand_hst              |
| opconditions               |
| operations                 |
| opgroup                    |
| opinventory                |
| opmessage                  |
| opmessage_grp              |
| opmessage_usr              |
| optemplate                 |
| problem                    |
| problem_tag                |
| profiles                   |
| proxy_autoreg_host         |
| proxy_dhistory             |
| proxy_history              |
| regexps                    |
| rights                     |
| role                       |
| role_rule                  |
| screen_user                |
| screen_usrgrp              |
| screens                    |
| screens_items              |
| scripts                    |
| service_alarms             |
| services                   |
| services_links             |
| services_times             |
| sessions                   |
| slides                     |
| slideshow_user             |
| slideshow_usrgrp           |
| slideshows                 |
| sysmap_element_trigger     |
| sysmap_element_url         |
| sysmap_shape               |
| sysmap_url                 |
| sysmap_user                |
| sysmap_usrgrp              |
| sysmaps                    |
| sysmaps_elements           |
| sysmaps_link_triggers      |
| sysmaps_links              |
| tag_filter                 |
| task                       |
| task_acknowledge           |
| task_check_now             |
| task_close_problem         |
| task_data                  |
| task_remote_command        |
| task_remote_command_result |
| task_result                |
| timeperiods                |
| trends                     |
| trends_uint                |
| trigger_depends            |
| trigger_discovery          |
| trigger_queue              |
| trigger_tag                |
| triggers                   |
| users                      |
| users_groups               |
| usrgrp                     |
| valuemaps                  |
| widget                     |
| widget_field               |
+----------------------------+
MariaDB [zabbix]> describe items;
+------------------+---------------------+------+-----+---------+-------+
| Field            | Type                | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------+-------+
| itemid           | bigint(20) unsigned | NO   | PRI | NULL    |       |
| type             | int(11)             | NO   |     | 0       |       |
| snmp_oid         | varchar(512)        | NO   |     |         |       |
| hostid           | bigint(20) unsigned | NO   | MUL | NULL    |       |
| name             | varchar(255)        | NO   |     |         |       |
| key_             | varchar(2048)       | NO   |     |         |       |
| delay            | varchar(1024)       | NO   |     | 0       |       |
| history          | varchar(255)        | NO   |     | 90d     |       |
| trends           | varchar(255)        | NO   |     | 365d    |       |
| status           | int(11)             | NO   | MUL | 0       |       |
| value_type       | int(11)             | NO   |     | 0       |       |
| trapper_hosts    | varchar(255)        | NO   |     |         |       |
| units            | varchar(255)        | NO   |     |         |       |
| formula          | varchar(255)        | NO   |     |         |       |
| logtimefmt       | varchar(64)         | NO   |     |         |       |
| templateid       | bigint(20) unsigned | YES  | MUL | NULL    |       |
| valuemapid       | bigint(20) unsigned | YES  | MUL | NULL    |       |
| params           | text                | NO   |     | NULL    |       |
| ipmi_sensor      | varchar(128)        | NO   |     |         |       |
| authtype         | int(11)             | NO   |     | 0       |       |
| username         | varchar(64)         | NO   |     |         |       |
| password         | varchar(64)         | NO   |     |         |       |
| publickey        | varchar(64)         | NO   |     |         |       |
| privatekey       | varchar(64)         | NO   |     |         |       |
| flags            | int(11)             | NO   |     | 0       |       |
| interfaceid      | bigint(20) unsigned | YES  | MUL | NULL    |       |
| description      | text                | NO   |     | NULL    |       |
| inventory_link   | int(11)             | NO   |     | 0       |       |
| lifetime         | varchar(255)        | NO   |     | 30d     |       |
| evaltype         | int(11)             | NO   |     | 0       |       |
| jmx_endpoint     | varchar(255)        | NO   |     |         |       |
| master_itemid    | bigint(20) unsigned | YES  | MUL | NULL    |       |
| timeout          | varchar(255)        | NO   |     | 3s      |       |
| url              | varchar(2048)       | NO   |     |         |       |
| query_fields     | varchar(2048)       | NO   |     |         |       |
| posts            | text                | NO   |     | NULL    |       |
| status_codes     | varchar(255)        | NO   |     | 200     |       |
| follow_redirects | int(11)             | NO   |     | 1       |       |
| post_type        | int(11)             | NO   |     | 0       |       |
| http_proxy       | varchar(255)        | NO   |     |         |       |
| headers          | text                | NO   |     | NULL    |       |
| retrieve_mode    | int(11)             | NO   |     | 0       |       |
| request_method   | int(11)             | NO   |     | 0       |       |
| output_format    | int(11)             | NO   |     | 0       |       |
| ssl_cert_file    | varchar(255)        | NO   |     |         |       |
| ssl_key_file     | varchar(255)        | NO   |     |         |       |
| ssl_key_password | varchar(64)         | NO   |     |         |       |
| verify_peer      | int(11)             | NO   |     | 0       |       |
| verify_host      | int(11)             | NO   |     | 0       |       |
| allow_traps      | int(11)             | NO   |     | 0       |       |
| discover         | int(11)             | NO   |     | 0       |       |
+------------------+---------------------+------+-----+---------+-------+

MariaDB [zabbix]> describe events;
+--------------+---------------------+------+-----+---------+-------+
| Field        | Type                | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+-------+
| eventid      | bigint(20) unsigned | NO   | PRI | NULL    |       |
| source       | int(11)             | NO   | MUL | 0       |       |
| object       | int(11)             | NO   |     | 0       |       |
| objectid     | bigint(20) unsigned | NO   |     | 0       |       |
| clock        | int(11)             | NO   |     | 0       |       |
| value        | int(11)             | NO   |     | 0       |       |
| acknowledged | int(11)             | NO   |     | 0       |       |
| ns           | int(11)             | NO   |     | 0       |       |
| name         | varchar(2048)       | NO   |     |         |       |
| severity     | int(11)             | NO   |     | 0       |       |
+--------------+---------------------+------+-----+---------+-------+

MariaDB [zabbix]> describe history;
+--------+---------------------+------+-----+---------+-------+
| Field  | Type                | Null | Key | Default | Extra |
+--------+---------------------+------+-----+---------+-------+
| itemid | bigint(20) unsigned | NO   | MUL | NULL    |       |
| clock  | int(11)             | NO   |     | 0       |       |
| value  | double              | NO   |     | 0       |       |
| ns     | int(11)             | NO   |     | 0       |       |
+--------+---------------------+------+-----+---------+-------+


MariaDB [zabbix]> describe hosts;
+--------------------+---------------------+------+-----+---------+-------+
| Field              | Type                | Null | Key | Default | Extra |
+--------------------+---------------------+------+-----+---------+-------+
| hostid             | bigint(20) unsigned | NO   | PRI | NULL    |       |
| proxy_hostid       | bigint(20) unsigned | YES  | MUL | NULL    |       |
| host               | varchar(128)        | NO   | MUL |         |       |
| status             | int(11)             | NO   | MUL | 0       |       |
| disable_until      | int(11)             | NO   |     | 0       |       |
| error              | varchar(2048)       | NO   |     |         |       |
| available          | int(11)             | NO   |     | 0       |       |
| errors_from        | int(11)             | NO   |     | 0       |       |
| lastaccess         | int(11)             | NO   |     | 0       |       |
| ipmi_authtype      | int(11)             | NO   |     | -1      |       |
| ipmi_privilege     | int(11)             | NO   |     | 2       |       |
| ipmi_username      | varchar(16)         | NO   |     |         |       |
| ipmi_password      | varchar(20)         | NO   |     |         |       |
| ipmi_disable_until | int(11)             | NO   |     | 0       |       |
| ipmi_available     | int(11)             | NO   |     | 0       |       |
| snmp_disable_until | int(11)             | NO   |     | 0       |       |
| snmp_available     | int(11)             | NO   |     | 0       |       |
| maintenanceid      | bigint(20) unsigned | YES  | MUL | NULL    |       |
| maintenance_status | int(11)             | NO   |     | 0       |       |
| maintenance_type   | int(11)             | NO   |     | 0       |       |
| maintenance_from   | int(11)             | NO   |     | 0       |       |
| ipmi_errors_from   | int(11)             | NO   |     | 0       |       |
| snmp_errors_from   | int(11)             | NO   |     | 0       |       |
| ipmi_error         | varchar(2048)       | NO   |     |         |       |
| snmp_error         | varchar(2048)       | NO   |     |         |       |
| jmx_disable_until  | int(11)             | NO   |     | 0       |       |
| jmx_available      | int(11)             | NO   |     | 0       |       |
| jmx_errors_from    | int(11)             | NO   |     | 0       |       |
| jmx_error          | varchar(2048)       | NO   |     |         |       |
| name               | varchar(128)        | NO   | MUL |         |       |
| flags              | int(11)             | NO   |     | 0       |       |
| templateid         | bigint(20) unsigned | YES  | MUL | NULL    |       |
| description        | text                | NO   |     | NULL    |       |
| tls_connect        | int(11)             | NO   |     | 1       |       |
| tls_accept         | int(11)             | NO   |     | 1       |       |
| tls_issuer         | varchar(1024)       | NO   |     |         |       |
| tls_subject        | varchar(1024)       | NO   |     |         |       |
| tls_psk_identity   | varchar(128)        | NO   |     |         |       |
| tls_psk            | varchar(512)        | NO   |     |         |       |
| proxy_address      | varchar(255)        | NO   |     |         |       |
| auto_compress      | int(11)             | NO   |     | 1       |       |
| discover           | int(11)             | NO   |     | 0       |       |
| custom_interfaces  | int(11)             | NO   |     | 0       |       |
+--------------------+---------------------+------+-----+---------+-------+
</code>