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...) |
|||
| Line 129: | Line 129: | ||
| ifserviceid | | ifserviceid | ||
| id | | id | ||
| + | |} | ||
| + | |||
| + | |||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- style="background:silver" | ||
| + | | '''Triggers | ||
| + | | '''Type | ||
| + | | '''Function | ||
| + | |||
| + | |- | ||
| + | | setifservicekeysoninserttrigger | ||
| + | | ROWBEFORE INSERT | ||
| + | | setifservicekeysoninsert | ||
| + | |- | ||
| + | | setifservicekeysonupdatetrigger | ||
| + | | ROWBEFORE UPDATE | ||
| + | | setifservicekeysonupdate | ||
|} | |} | ||
Revision as of 14:41, 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 |
| Triggers | Type | Function |
| setifservicekeysoninserttrigger | ROWBEFORE INSERT | setifservicekeysoninsert |
| setifservicekeysonupdatetrigger | ROWBEFORE UPDATE | setifservicekeysonupdate |
