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 »
Back
History
public.outages_(table)
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | public.outages |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | outageid | integer | not null | | |- valign="top" | svclosteventid | integer | null | | |- valign="top" | svcregainedeventid | integer | null | | |- valign="top" | nodeid | integer | not null | | |- valign="top" | ipaddr | varchar(16) | not null | | |- valign="top" | serviceid | integer | not null | | |- valign="top" | iflostservice | timestamp with time zone | not null | | |- valign="top" | ifregainedservice | timestamp with time zone | null | | |- valign="top" | suppresstime | timestamp with time zone | null | | |- valign="top" | suppressedby | varchar(256) | null | | |- valign="top" | ifserviceid | integer | not null | | |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | pk_outageid | outageid |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | outages_ifservivceid_idx | | ifserviceid |- valign="top" | outages_ipaddr_idx | | ipaddr |- valign="top" | outages_nodeid_idx | | nodeid |- valign="top" | outages_nodeid_ipaddr_svc_idx | | nodeid, ipaddr, serviceid |- valign="top" | outages_regainedservice_idx | | ifregainedservice |- valign="top" | outages_serviceid_idx | | serviceid |- valign="top" | outages_svclostid_idx | | svclosteventid |- valign="top" | outages_svcregainedid_idx | | svcregainedeventid |} === Foreign Keys === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- valign="top" | [[public.events_(table)|public.events]] | svclosteventid | eventid |- valign="top" | [[public.events_(table)|public.events]] | svcregainedeventid | eventid |- valign="top" | [[public.node_(table)|public.node]] | nodeid | nodeid |- valign="top" | [[public.service_(table)|public.service]] | serviceid | serviceid |- valign="top" | [[public.ifservices_(table)|public.ifservices]] | nodeid | nodeid |- valign="top" | [[public.ifservices_(table)|public.ifservices]] | ifserviceid | id |} === Triggers === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Trigger''' | '''Type''' | '''Function''' |- valign="top" | setifservicekeysoninserttrigger | STATEMENT AFTER | setifservicekeysoninsert |- valign="top" | setifservicekeysonupdatetrigger | STATEMENT AFTER | setifservicekeysonupdate |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.