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

Docs/DB schema/2.0/alerts

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
alertid NONE NOT NULL id
actionid NONE NOT NULL id actions.actionid C
eventid NONE NOT NULL id events.eventid C
userid NONE NULL id users.userid C
clock 0 NOT NULL time
mediatypeid NONE NULL id media_type.mediatypeid C
sendto EMPTY NOT NULL varchar(100)
subject EMPTY NOT NULL varchar(255)
message EMPTY NOT NULL text
status 0 NOT NULL integer
retries 0 NOT NULL integer
error EMPTY NOT NULL varchar(128)
nextcheck [!] 0 NOT NULL integer
esc_step 0 NOT NULL integer
alerttype 0 NOT NULL integer

Indexes

Name UNIQ Columns
PRIMARY KEY YES alertid
alerts_1 No actionid
alerts_2 No clock
alerts_3 No eventid
alerts_4 No status, retries
alerts_5 No mediatypeid
alerts_6 No userid