See for the official Zabbix site.

Docs/DB schema/trunk/triggers

Jump to: navigation, search

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


Column Detail Default NULL? Type Ref from Ref to
triggerid NONE NOT NULL id escalations.triggerid
functions.triggerid C
services.triggerid C
sysmap_element_trigger.triggerid C
sysmaps_link_triggers.triggerid C
trigger_depends.triggerid_down C
trigger_depends.triggerid_up C
trigger_discovery.triggerid C
trigger_tag.triggerid C
triggers.templateid C
expression EMPTY NOT NULL varchar(2048)
description EMPTY NOT NULL varchar(255)
url EMPTY NOT NULL varchar(255)
status 0 NOT NULL integer
value 0 NOT NULL integer
priority 0 NOT NULL integer
lastchange 0 NOT NULL integer
comments EMPTY NOT NULL shorttext
error EMPTY NOT NULL varchar(2048)
templateid NONE NULL id triggers.triggerid C
type 0 NOT NULL integer
state 0 NOT NULL integer
flags 0 NOT NULL integer
recovery_mode 0 NOT NULL integer
recovery_expression EMPTY NOT NULL varchar(2048)
correlation_mode 0 NOT NULL integer
correlation_tag EMPTY NOT NULL varchar(255)
manual_close 0 NOT NULL integer


Name UNIQ Columns
triggers_1 No status
triggers_2 No value, lastchange
triggers_3 No templateid