Public.outages (table)

wikibot

Table

public.outages

Column	Data Type	Nullable	Default	PK	Index
outageid	integer	not null		pk_outageid
svclosteventid	integer	null			outages_svclostid_idx
svcregainedeventid	integer	null			outages_svcregainedid_idx
nodeid	integer	not null			outages_nodeid_ipaddr_svc_idxoutages_nodeid_idx
ipaddr	varchar(16)	not null			outages_nodeid_ipaddr_svc_idxoutages_ipaddr_idx
serviceid	integer	not null			outages_serviceid_idxoutages_nodeid_ipaddr_svc_idx
iflostservice	timestamp with time zone	not null
ifregainedservice	timestamp with time zone	null			outages_regainedservice_idx
suppresstime	timestamp with time zone	null
suppressedby	varchar(256)	null
ifserviceid	integer	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