Difference between revisions of "Public.outages (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.outages |- |} {| border="1" cellpadding="5" cellspacing="0" style="bo...) |
(No difference)
|
Revision as of 15:14, 7 August 2009
wikibot
Table | public.outages |
Column | Data Type | Nullable | Default | PK | Index |
outageid | not null | pk_outageid | |||
svclosteventid | null | outages_svclostid_idx | |||
svcregainedeventid | null | outages_svcregainedid_idx | |||
nodeid | not null | outages_nodeid_ipaddr_svc_idxoutages_nodeid_idx | |||
ipaddr | not null | outages_nodeid_ipaddr_svc_idxoutages_ipaddr_idx | |||
serviceid | not null | outages_serviceid_idxoutages_nodeid_ipaddr_svc_idx | |||
iflostservice | not null | ||||
ifregainedservice | null | outages_regainedservice_idx | |||
suppresstime | null | ||||
suppressedby | null | ||||
ifserviceid | not null | outages_ifservivceid_idx |
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 |