See for the official Zabbix site.

Docs/DB schema/4.0/alerts

Jump to: navigation, search

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


Column Detail Default NULL? Type Ref from Ref to
alertid NONE NOT NULL id task_remote_command.alertid
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(1024)
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(2048)
esc_step 0 NOT NULL integer
alerttype 0 NOT NULL integer
p_eventid NONE NULL id events.eventid C
acknowledgeid NONE NULL id acknowledges.acknowledgeid C


Name UNIQ Columns
alerts_1 No actionid
alerts_2 No clock
alerts_3 No eventid
alerts_4 No status
alerts_5 No mediatypeid
alerts_6 No userid
alerts_7 No p_eventid