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 14: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 |
