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

Docs/DB schema/2.2/triggers

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
triggerid NONE NOT NULL id escalations.triggerid
functions.triggerid C
services.triggerid C
sysmaps_link_triggers.triggerid C
trigger_depends.triggerid_down C
trigger_depends.triggerid_up C
trigger_discovery.parent_triggerid C
trigger_discovery.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(128)
templateid NONE NULL id triggers.triggerid C
type 0 NOT NULL integer
state 0 NOT NULL integer
flags 0 NOT NULL integer

Indexes

Name UNIQ Columns
PRIMARY KEY YES triggerid
triggers_1 No status
triggers_2 No value
triggers_3 No templateid