ScrewTurn Wiki

Tablepublic.outages

Edit

Columns

ColumnData TypeNullableDefaultDescription
outageidintegernot null  
svclosteventidintegernull  
svcregainedeventidintegernull  
nodeidintegernot null  
ipaddrvarchar(16)not null  
serviceidintegernot null  
iflostservicetimestamp with time zonenot null  
ifregainedservicetimestamp with time zonenull  
suppresstimetimestamp with time zonenull  
suppressedbyvarchar(256)null  
ifserviceidintegernot null  

Edit

Primary Key

Primary KeyColumns
pk_outageidoutageid

Edit

Indexes

IndexTypeColumns
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

Edit

Foreign Keys

RelationColumnReferenced Column
public.eventssvclosteventideventid
public.eventssvcregainedeventideventid
public.nodenodeidnodeid
public.serviceserviceidserviceid
public.ifservicesnodeidnodeid
public.ifservicesifserviceidid

Edit

Triggers

TriggerTypeFunction
setifservicekeysoninserttriggerSTATEMENT AFTERsetifservicekeysoninsert
setifservicekeysonupdatetriggerSTATEMENT AFTERsetifservicekeysonupdate

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.