ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
public.outages_(table)
Print
RSS
Modified: 2011/08/27 10:41 by
wikibot
-
Uncategorized
»
public.eventsnxtid_(sequence)
»
public.element_(table)
»
public.outages_(table)
[X]
»
public.eventsnxtid_(sequence)
»
public.element_(table)
»
public.outages_(table)
Table
public.outages
Edit
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
Edit
Primary Key
Primary Key
Columns
pk_outageid
outageid
Edit
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
Edit
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
Edit
Triggers
Trigger
Type
Function
setifservicekeysoninserttrigger
STATEMENT AFTER
setifservicekeysoninsert
setifservicekeysonupdatetrigger
STATEMENT AFTER
setifservicekeysonupdate
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.