Docs/DB schema/trunk/triggers

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 sysmap_element_trigger.triggerid C sysmaps_link_triggers.triggerid C trigger_depends.triggerid_down C trigger_depends.triggerid_up C trigger_discovery.parent_triggerid 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

Indexes

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