Public.outages (table)

wikibot

Table

public.outages

Columns

Column	Data Type	Nullable	Default	Description
outageid	integer	not null
svclosteventid	integer	null
svcregainedeventid	integer	null
nodeid	integer	not null
ipaddr	varchar(16)	not null
serviceid	integer	not null
iflostservice	timestamp with time zone	not null
ifregainedservice	timestamp with time zone	null
suppresstime	timestamp with time zone	null
suppressedby	varchar(256)	null
ifserviceid	integer	not null

Primary Key

Primary Key	Columns
pk_outageid	outageid

Indexes

Index	Type	Columns
outages_ifservivceid_idx		ifserviceid
outages_ipaddr_idx		ipaddr
outages_nodeid_idx		nodeid
outages_nodeid_ipaddr_svc_idx		nodeid, ipaddr, serviceid
outages_regainedservice_idx		ifregainedservice
outages_serviceid_idx		serviceid
outages_svclostid_idx		svclosteventid
outages_svcregainedid_idx		svcregainedeventid

Foreign Keys

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

Trigger	Type	Function
setifservicekeysoninserttrigger	STATEMENT AFTER	setifservicekeysoninsert
setifservicekeysonupdatetrigger	STATEMENT AFTER	setifservicekeysonupdate