Docs/DB schema/4.0/actions

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

Columns

Column	Detail	Default	NULL?	Type	Ref from	Ref to
actionid		NONE	NOT NULL	id		alerts.actionid C conditions.actionid C escalations.actionid operations.actionid C
name		EMPTY	NOT NULL	varchar(255)
eventsource		0	NOT NULL	integer
evaltype		0	NOT NULL	integer
status		0	NOT NULL	integer
esc_period		1h	NOT NULL	varchar(255)
def_shortdata		EMPTY	NOT NULL	varchar(255)
def_longdata		EMPTY	NOT NULL	shorttext
r_shortdata		EMPTY	NOT NULL	varchar(255)
r_longdata		EMPTY	NOT NULL	shorttext
formula		EMPTY	NOT NULL	varchar(255)
pause_suppressed	Renamed from "maintenance_mode" in 4.0.	1	NOT NULL	integer
ack_shortdata		EMPTY	NOT NULL	varchar(255)
ack_longdata		EMPTY	NOT NULL	shorttext

Indexes

Name	UNIQ	Columns
PRIMARY KEY	YES	actionid
actions_1	No	eventsource, status
actions_2	YES	name