Public.ifservices (table) - Revision history

Bot at 09:25, 27 August 2011

2011-08-27T09:25:02Z

Bot at 09:19, 27 August 2011

2011-08-27T09:19:37Z

Bot at 09:09, 27 August 2011

2011-08-27T09:09:28Z

Bot at 22:38, 24 June 2010

2010-06-24T22:38:56Z

Show changes

Bot at 07:31, 11 February 2010

2010-02-11T07:31:50Z

Bot at 13:46, 7 August 2009

2009-08-07T13:46:55Z

Bot at 13:43, 7 August 2009

2009-08-07T13:43:05Z

Bot at 13:40, 7 August 2009

2009-08-07T13:40:56Z

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

2009-08-07T13:14:07Z

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

New page

== wikibot ==

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

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''PK
| '''Index

|-
| id
|
| not null
| nextval('opennmsnxtid'::regclass)
| ifservices_pkey
|
|-
| nodeid
|
| not null
|
|
| ifservices_nodeid_ipaddr_svc_uniqueifservices_nodeid_ipaddr_statusifservices_nodeid_statusifservices_nodeid_idxifservices_nodeid_serviceid_idx
|-
| ipaddr
|
| not null
|
|
| ifservices_nodeid_ipaddr_svc_uniqueifservices_nodeid_ipaddr_status
|-
| ifindex
|
| null
|
|
|
|-
| serviceid
|
| not null
|
|
| ifservices_nodeid_ipaddr_svc_uniqueifservices_serviceid_idxifservices_nodeid_serviceid_idx
|-
| lastgood
|
| null
|
|
|
|-
| lastfail
|
| null
|
|
|
|-
| qualifier
|
| null
|
|
|
|-
| status
|
| null
|
|
| ifservices_nodeid_ipaddr_statusifservices_nodeid_status
|-
| source
|
| null
|
|
|
|-
| notify
|
| null
|
|
|
|-
| ipinterfaceid
|
| not null
|
|
| ifservicves_ipinterfaceid_idx
|}

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

|-
| [[public.node_(table)|public.node]]
| nodeid
| nodeid
|-
| [[public.service_(table)|public.service]]
| serviceid
| serviceid
|-
| [[public.ipinterface_(table)|public.ipinterface]]
| ipinterfaceid
| id
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column

|-
| [[public.outages_(table)|public.outages]]
| nodeid
| nodeid
|-
| [[public.outages_(table)|public.outages]]
| nodeid
| nodeid
|-
| [[public.outages_(table)|public.outages]]
| nodeid
| nodeid
|-
| [[public.outages_(table)|public.outages]]
| id
| ifserviceid
|-
| [[public.application_service_map_(table)|public.application_service_map]]
| id
| ifserviceid
|-
| [[public.location_specific_status_changes_(table)|public.location_specific_status_changes]]
| id
| ifserviceid
|}

@@ Line 117: / Line 117: @@
 |- valign="top"
 | ifservices_nodeid_ipaddr_svc_unique
-| Unique
 | nodeid, ipaddr, serviceid
 |- valign="top"
@@ Line 191: / Line 191: @@
 |- valign="top"
 | setipinterfacekeysoninserttrigger
-| ROW BEFORE INSERT
+| STATEMENT AFTER
 | setipinterfacekeysoninsert
 |- valign="top"
 | setipinterfacekeysonupdatetrigger
-| ROW BEFORE UPDATE
+| STATEMENT AFTER
 | setipinterfacekeysonupdate
 |}

@@ Line 20: / Line 20: @@
 | integer
 | not null
-| nextval('opennmsnxtid'::regclass)
+|
 |- valign="top"
@@ Line 107: / Line 107: @@
 | '''Columns
 |- valign="top"
 | ifservices_nodeid_ipaddr_svc_unique
@@ Line 112: / Line 120: @@
 | nodeid, ipaddr, serviceid
 |- valign="top"
-| ifservices_serviceid_idx
+| ifservices_nodeid_serviceid_idx
+|
-| serviceid
+| nodeid, serviceid
 |- valign="top"
-| ifservices_nodeid_ipaddr_status
+| ifservices_nodeid_status
+|
-| nodeid, ipaddr, status
+| nodeid, status
 |- valign="top"
-| ifservices_nodeid_status
+| ifservices_serviceid_idx
+|
-| nodeid, status
+| serviceid
 |- valign="top"
 | ifservicves_ipinterfaceid_idx
+|
 | ipinterfaceid
 |}
@@ Line 156: / Line 156: @@
 | ipinterfaceid
 | id
 |- valign="top"
-| [[public.outages_(table)|public.outages]]
+| [[public.ifservices_(table)|public.ifservices]]
 | nodeid
 | nodeid
 |- valign="top"
-| [[public.outages_(table)|public.outages]]
+| [[public.ifservices_(table)|public.ifservices]]
 | nodeid
 | nodeid
 |- valign="top"
-| [[public.outages_(table)|public.outages]]
+| [[public.ifservices_(table)|public.ifservices]]
 | nodeid
 | nodeid
 |- valign="top"
-| [[public.outages_(table)|public.outages]]
+| [[public.ifservices_(table)|public.ifservices]]
 | id
 | ifserviceid
 |- valign="top"
-| [[public.application_service_map_(table)|public.application_service_map]]
+| [[public.ifservices_(table)|public.ifservices]]
 | ifserviceid
 | id
 |}

@@ 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
 | nextval('opennmsnxtid'::regclass)
+|
 |-
@@ Line 31: / Line 30: @@
+|
+|
 |-
 | ipaddr
@@ Line 38: / Line 36: @@
+|
+|
 |-
 | ifindex
 | integer
 | null
+|
+|
@@ Line 52: / Line 48: @@
+|
+|
 |-
 | lastgood
 | timestamp with time zone
 | null
+|
+|
@@ Line 64: / Line 58: @@
 | timestamp with time zone
 | null
+|
+|
@@ Line 71: / Line 64: @@
 | char(16)
 | null
+|
+|
@@ Line 80: / Line 72: @@
+|
+|
 |-
 | source
 | char(1)
 | null
+|
+|
@@ Line 92: / Line 82: @@
 | char(1)
 | null
+|
+|
@@ Line 101: / Line 90: @@
+|
+|
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 126: / Line 160: @@
 |}
+=== Detail Tables ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 160: / Line 194: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 174: / Line 209: @@
 | ROW BEFORE UPDATE
 | setipinterfacekeysonupdate
 |}

@@ Line 168: / Line 168: @@
 |-
 | setipinterfacekeysoninserttrigger
-| ROWBEFORE INSERT
+| ROW BEFORE INSERT
 | setipinterfacekeysoninsert
 |-
 | setipinterfacekeysonupdatetrigger
-| ROWBEFORE UPDATE
+| ROW BEFORE UPDATE
 | setipinterfacekeysonupdate
 |}