Difference between revisions of "Public.outages (table)"
Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
− | |- | + | |- valign="top" |
| '''Table | | '''Table | ||
| public.outages | | public.outages | ||
− | |||
|} | |} | ||
− | |||
=== Columns === | === Columns === | ||
Line 17: | Line 15: | ||
| '''Default | | '''Default | ||
| '''Description | | '''Description | ||
− | + | ||
− | |- | + | |- valign="top" |
| outageid | | outageid | ||
| integer | | integer | ||
Line 24: | Line 22: | ||
| | | | ||
| | | | ||
− | |- | + | |- valign="top" |
| svclosteventid | | svclosteventid | ||
| integer | | integer | ||
Line 30: | Line 28: | ||
| | | | ||
| | | | ||
− | |- | + | |- valign="top" |
| svcregainedeventid | | svcregainedeventid | ||
| integer | | integer | ||
Line 36: | Line 34: | ||
| | | | ||
| | | | ||
− | |- | + | |- valign="top" |
| nodeid | | nodeid | ||
| integer | | integer | ||
Line 42: | Line 40: | ||
| | | | ||
| | | | ||
− | |- | + | |- valign="top" |
| ipaddr | | ipaddr | ||
| varchar(16) | | varchar(16) | ||
Line 48: | Line 46: | ||
| | | | ||
| | | | ||
− | |- | + | |- valign="top" |
| serviceid | | serviceid | ||
| integer | | integer | ||
Line 54: | Line 52: | ||
| | | | ||
| | | | ||
− | |- | + | |- valign="top" |
| iflostservice | | iflostservice | ||
| timestamp with time zone | | timestamp with time zone | ||
Line 60: | Line 58: | ||
| | | | ||
| | | | ||
− | |- | + | |- valign="top" |
| ifregainedservice | | ifregainedservice | ||
| timestamp with time zone | | timestamp with time zone | ||
Line 66: | Line 64: | ||
| | | | ||
| | | | ||
− | |- | + | |- valign="top" |
| suppresstime | | suppresstime | ||
| timestamp with time zone | | timestamp with time zone | ||
Line 72: | Line 70: | ||
| | | | ||
| | | | ||
− | |- | + | |- valign="top" |
| suppressedby | | suppressedby | ||
| varchar(256) | | varchar(256) | ||
Line 78: | Line 76: | ||
| | | | ||
| | | | ||
− | |- | + | |- valign="top" |
| ifserviceid | | ifserviceid | ||
| integer | | integer | ||
Line 91: | Line 89: | ||
| '''Primary Key | | '''Primary Key | ||
| '''Columns | | '''Columns | ||
− | |- | + | |- valign="top" |
| pk_outageid | | pk_outageid | ||
| outageid | | outageid | ||
Line 102: | Line 100: | ||
| '''Type | | '''Type | ||
| '''Columns | | '''Columns | ||
− | + | ||
− | |- | + | |- valign="top" |
| outages_ifservivceid_idx | | outages_ifservivceid_idx | ||
| | | | ||
| ifserviceid | | ifserviceid | ||
− | |- | + | |- valign="top" |
| outages_svcregainedid_idx | | outages_svcregainedid_idx | ||
| | | | ||
| svcregainedeventid | | svcregainedeventid | ||
− | |- | + | |- valign="top" |
| outages_svclostid_idx | | outages_svclostid_idx | ||
| | | | ||
| svclosteventid | | svclosteventid | ||
− | |- | + | |- valign="top" |
| outages_serviceid_idx | | outages_serviceid_idx | ||
| | | | ||
| serviceid | | serviceid | ||
− | |- | + | |- valign="top" |
| outages_regainedservice_idx | | outages_regainedservice_idx | ||
| | | | ||
| ifregainedservice | | ifregainedservice | ||
− | |- | + | |- valign="top" |
| outages_nodeid_ipaddr_svc_idx | | outages_nodeid_ipaddr_svc_idx | ||
| | | | ||
| nodeid, ipaddr, serviceid | | nodeid, ipaddr, serviceid | ||
− | |- | + | |- valign="top" |
| outages_nodeid_idx | | outages_nodeid_idx | ||
| | | | ||
| nodeid | | nodeid | ||
− | |- | + | |- valign="top" |
| outages_ipaddr_idx | | outages_ipaddr_idx | ||
| | | | ||
Line 143: | Line 141: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
− | + | ||
− | |- | + | |- valign="top" |
| [[public.events_(table)|public.events]] | | [[public.events_(table)|public.events]] | ||
| svclosteventid | | svclosteventid | ||
| eventid | | eventid | ||
− | |- | + | |- valign="top" |
| [[public.events_(table)|public.events]] | | [[public.events_(table)|public.events]] | ||
| svcregainedeventid | | svcregainedeventid | ||
| eventid | | eventid | ||
− | |- | + | |- valign="top" |
| [[public.node_(table)|public.node]] | | [[public.node_(table)|public.node]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- valign="top" |
| [[public.service_(table)|public.service]] | | [[public.service_(table)|public.service]] | ||
| serviceid | | serviceid | ||
| serviceid | | serviceid | ||
− | |- | + | |- valign="top" |
| [[public.ifservices_(table)|public.ifservices]] | | [[public.ifservices_(table)|public.ifservices]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- valign="top" |
| [[public.ifservices_(table)|public.ifservices]] | | [[public.ifservices_(table)|public.ifservices]] | ||
| ifserviceid | | ifserviceid | ||
Line 173: | Line 171: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
− | | ''' | + | | '''Trigger |
| '''Type | | '''Type | ||
| '''Function | | '''Function | ||
− | + | ||
− | |- | + | |- valign="top" |
| setifservicekeysoninserttrigger | | setifservicekeysoninserttrigger | ||
| ROW BEFORE INSERT | | ROW BEFORE INSERT | ||
| setifservicekeysoninsert | | setifservicekeysoninsert | ||
− | |- | + | |- valign="top" |
| setifservicekeysonupdatetrigger | | setifservicekeysonupdatetrigger | ||
| ROW BEFORE UPDATE | | ROW BEFORE UPDATE | ||
Line 194: | Line 192: | ||
| '''Referencing Object | | '''Referencing Object | ||
− | |- | + | |- valign="top" |
| Select | | Select | ||
| Function | | Function |
Revision as of 23:39, 24 June 2010
Contents
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 |