See www.zabbix.com for the official Zabbix site.

Docs/DB schema/2.0/history log

From Zabbix.org
Jump to: navigation, search

This table contains [please add a brief table description].

Columns

Column Detail Default NULL? Type Ref from Ref to
id NONE NOT NULL id
itemid NONE NOT NULL id items.itemid
clock 0 NOT NULL time
timestamp 0 NOT NULL time
source EMPTY NOT NULL varchar(64)
severity 0 NOT NULL integer
value EMPTY NOT NULL history_log
logeventid 0 NOT NULL integer
ns 0 NOT NULL nanosec

Indexes

Name UNIQ Columns
PRIMARY KEY YES id
history_log_1 No itemid, clock
history_log_2 YES itemid, id