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

Docs/DB schema/2.4/operations

From Zabbix.org

Jump to: navigation, search

operations
2.0 \| 2.2 \| 2.4 \| 3.0 \| 3.2 \| 3.4 \| 4.0 \| trunk
A
acknowledges actions alerts application_template [*] applications auditlog auditlog_details autoreg_host
C
conditions config
D
dbversion [*] dchecks dhosts drules dservices
E
escalations events expressions
F
functions
G
globalmacro globalvars graph_discovery graph_theme graphs graphs_items group_discovery [] group_prototype [] groups
H
history history_log history_str history_text history_uint host_discovery [*] host_inventory hostmacro hosts hosts_groups hosts_templates housekeeper httpstep httpstepitem httptest httptestitem
I
icon_map icon_mapping ids images interface interface_discovery [] item_condition [] item_discovery items items_applications
M
maintenances maintenances_groups maintenances_hosts maintenances_windows mappings media media_type
O
opcommand opcommand_grp opcommand_hst opconditions operations opgroup opmessage opmessage_grp opmessage_usr optemplate
P
profiles proxy_autoreg_host proxy_dhistory proxy_history
R
regexps rights
S
screens screens_items scripts service_alarms services services_links services_times sessions slides slideshows sysmap_element_url sysmap_url sysmaps sysmaps_elements sysmaps_link_triggers sysmaps_links
T
timeperiods trends trends_uint trigger_depends trigger_discovery triggers
U
user_history [!] users users_groups usrgrp
V
valuemaps

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

Columns

Column	Default	NULL?	Type	Ref from	Ref to
operationid	NONE	NOT NULL	id		opcommand.operationid C opcommand_grp.operationid C opcommand_hst.operationid C opconditions.operationid C opgroup.operationid C opmessage.operationid C opmessage_grp.operationid C opmessage_usr.operationid C optemplate.operationid C
actionid	NONE	NOT NULL	id	actions.actionid C
operationtype	0	NOT NULL	integer
esc_period	0	NOT NULL	integer
esc_step_from	1	NOT NULL	integer
esc_step_to	1	NOT NULL	integer
evaltype	0	NOT NULL	integer

Name	UNIQ	Columns
PRIMARY KEY	YES	operationid
operations_1	No	actionid