Public.outages (table)

From dbscript Online Help
Revision as of 23:39, 24 June 2010 by Bot (talk | contribs)
Jump to: navigation, search

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_svcregainedid_idx svcregainedeventid
outages_svclostid_idx svclosteventid
outages_serviceid_idx serviceid
outages_regainedservice_idx ifregainedservice
outages_nodeid_ipaddr_svc_idx nodeid, ipaddr, serviceid
outages_nodeid_idx nodeid
outages_ipaddr_idx ipaddr

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 ROW BEFORE INSERT setifservicekeysoninsert
setifservicekeysonupdatetrigger ROW BEFORE UPDATE setifservicekeysonupdate

Dependencies

Reference Type Object Type Referencing Object
Select Function public.getoutagetimeinwindow