Public.outages (table)

wikibot

Table

public.outages

Column	Data Type	Nullable	Default	PK	Index
outageid		not null		pk_outageid
svclosteventid		null			outages_svclostid_idx
svcregainedeventid		null			outages_svcregainedid_idx
nodeid		not null			outages_nodeid_ipaddr_svc_idxoutages_nodeid_idx
ipaddr		not null			outages_nodeid_ipaddr_svc_idxoutages_ipaddr_idx
serviceid		not null			outages_serviceid_idxoutages_nodeid_ipaddr_svc_idx
iflostservice		not null
ifregainedservice		null			outages_regainedservice_idx
suppresstime		null
suppressedby		null
ifserviceid		not null			outages_ifservivceid_idx

Relation	Column	Referenced Column
public.events	svclosteventid	eventid
public.events	svcregainedeventid	eventid
public.node	nodeid	nodeid
public.service	serviceid	serviceid
public.ifservices	nodeid	nodeid
public.ifservices	ifserviceid	id

Triggers	Type	Function
setifservicekeysoninserttrigger	ROWBEFORE INSERT	setifservicekeysoninsert
setifservicekeysonupdatetrigger	ROWBEFORE UPDATE	setifservicekeysonupdate