From dbscript Online Help
wikibot
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
Triggers
Trigger
|
Type
|
Function
|
setifservicekeysoninserttrigger
|
ROW BEFORE INSERT
|
setifservicekeysoninsert
|
setifservicekeysonupdatetrigger
|
ROW BEFORE UPDATE
|
setifservicekeysonupdate
|
Dependencies