Public.outages (table) - Revision history

Bot at 09:19, 27 August 2011

2011-08-27T09:19:58Z

Bot at 09:09, 27 August 2011

2011-08-27T09:09:47Z

Bot at 22:39, 24 June 2010

2010-06-24T22:39:16Z

Show changes

Bot at 07:32, 11 February 2010

2010-02-11T07:32:13Z

Bot at 13:47, 7 August 2009

2009-08-07T13:47:25Z

Bot at 13:43, 7 August 2009

2009-08-07T13:43:27Z

Bot at 13:41, 7 August 2009

2009-08-07T13:41:12Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.outages |- |} {| border="1" cellpadding="5" cellspacing="0" style="bo...

2009-08-07T13:14:24Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.outages |- |} {| border="1" cellpadding="5" cellspacing="0" style="bo...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| public.outages
|-
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''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
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation
| '''Column
| '''Referenced Column

|-
| [[public.events_(table)|public.events]]
| svclosteventid
| eventid
|-
| [[public.events_(table)|public.events]]
| svcregainedeventid
| eventid
|-
| [[public.node_(table)|public.node]]
| nodeid
| nodeid
|-
| [[public.service_(table)|public.service]]
| serviceid
| serviceid
|-
| [[public.ifservices_(table)|public.ifservices]]
| nodeid
| nodeid
|-
| [[public.ifservices_(table)|public.ifservices]]
| ifserviceid
| id
|}

@@ Line 177: / Line 177: @@
 |- valign="top"
 | setifservicekeysoninserttrigger
-| ROW BEFORE INSERT
+| STATEMENT AFTER
 | setifservicekeysoninsert
 |- valign="top"
 | setifservicekeysonupdatetrigger
-| ROW BEFORE UPDATE
+| STATEMENT AFTER
 | setifservicekeysonupdate
 |}

@@ Line 140: / Line 140: @@
 |-
 | setifservicekeysoninserttrigger
-| ROWBEFORE INSERT
+| ROW BEFORE INSERT
 | setifservicekeysoninsert
 |-
 | setifservicekeysonupdatetrigger
-| ROWBEFORE UPDATE
+| ROW BEFORE UPDATE
 | setifservicekeysonupdate
 |}

@@ Line 106: / Line 106: @@
 | ifserviceid
 |- valign="top"
-| outages_svcregainedid_idx
+| outages_ipaddr_idx
+|
-| svcregainedeventid
+| ipaddr
 |- valign="top"
-| outages_svclostid_idx
+| outages_nodeid_idx
+|
-| svclosteventid
+| nodeid
 |- valign="top"
-| outages_serviceid_idx
+| outages_nodeid_ipaddr_svc_idx
+|
-| serviceid
+| nodeid, ipaddr, serviceid
 |- valign="top"
 | outages_regainedservice_idx
@@ Line 122: / Line 122: @@
 | ifregainedservice
 |- valign="top"
-| outages_nodeid_ipaddr_svc_idx
+| outages_serviceid_idx
+|
-| nodeid, ipaddr, serviceid
+| serviceid
 |- valign="top"
-| outages_nodeid_idx
+| outages_svclostid_idx
+|
-| nodeid
+| svclosteventid
 |- valign="top"
-| outages_ipaddr_idx
+| outages_svcregainedid_idx
+|
-| ipaddr
+| svcregainedeventid
 |}

@@ Line 9: / Line 9: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 15: / Line 16: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description
 |-
@@ Line 23: / Line 23: @@
 | not null
+|
+|
 |-
@@ Line 31: / Line 30: @@
+|
+|
 |-
 | svcregainedeventid
@@ Line 38: / Line 36: @@
+|
+|
 |-
 | nodeid
@@ Line 45: / Line 42: @@
+|
+|
 |-
 | ipaddr
@@ Line 52: / Line 48: @@
+|
+|
 |-
 | serviceid
@@ Line 59: / Line 54: @@
+|
+|
 |-
 | iflostservice
 | timestamp with time zone
 | not null
+|
+|
@@ Line 73: / Line 66: @@
+|
+|
 |-
 | suppresstime
 | timestamp with time zone
 | null
+|
+|
@@ Line 85: / Line 76: @@
 | varchar(256)
 | null
+|
+|
@@ Line 94: / Line 84: @@
+|
+|
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 131: / Line 170: @@
 |}
+=== Triggers ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 146: / Line 185: @@
 | ROW BEFORE UPDATE
 | setifservicekeysonupdate
 |}

@@ Line 20: / Line 20: @@
 |-
 | outageid
+| integer
 | not null
+|
@@ Line 27: / Line 27: @@
 |-
 | svclosteventid
+| integer
 | null
+|
@@ Line 34: / Line 34: @@
 |-
 | svcregainedeventid
+| integer
 | null
+|
@@ Line 41: / Line 41: @@
 |-
 | nodeid
+| integer
 | not null
+|
@@ Line 48: / Line 48: @@
 |-
 | ipaddr
+| varchar(16)
 | not null
+|
@@ Line 55: / Line 55: @@
 |-
 | serviceid
+| integer
 | not null
+|
@@ Line 62: / Line 62: @@
 |-
 | iflostservice
+| timestamp with time zone
 | not null
+|
@@ Line 69: / Line 69: @@
 |-
 | ifregainedservice
+| timestamp with time zone
 | null
+|
@@ Line 76: / Line 76: @@
 |-
 | suppresstime
+| timestamp with time zone
 | null
+|
@@ Line 83: / Line 83: @@
 |-
 | suppressedby
+| varchar(256)
 | null
+|
@@ Line 90: / Line 90: @@
 |-
 | ifserviceid
+| integer
 | not null
+|