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