Public.ipinterface (table) - Revision history

Bot at 09:25, 27 August 2011

2011-08-27T09:25:05Z

Bot at 09:19, 27 August 2011

2011-08-27T09:19:40Z

Bot at 09:09, 27 August 2011

2011-08-27T09:09:31Z

Bot at 22:38, 24 June 2010

2010-06-24T22:38:59Z

Show changes

Bot at 07:31, 11 February 2010

2010-02-11T07:31:53Z

Bot at 13:47, 7 August 2009

2009-08-07T13:47:01Z

Bot at 13:43, 7 August 2009

2009-08-07T13:43:09Z

Bot at 13:41, 7 August 2009

2009-08-07T13:41:00Z

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

2009-08-07T13:14:10Z

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

New page

== wikibot ==

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

{| 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)
| ipinterface_pkey
|
|-
| nodeid
|
| not null
|
|
| ipinterface_nodeid_ipaddr_notzero_idxipinterface_nodeid_idxipinterface_nodeid_ipaddr_ismanaged_idx
|-
| ipaddr
|
| not null
|
|
| ipinterface_nodeid_ipaddr_notzero_idxipinterface_nodeid_ismanaged_idxipinterface_ipaddr_idxipinterface_ipaddr_ismanaged_idxipinterface_nodeid_ipaddr_ismanaged_idx
|-
| ifindex
|
| null
|
|
|
|-
| iphostname
|
| null
|
|
|
|-
| ismanaged
|
| null
|
|
| ipinterface_ipaddr_ismanaged_idxipinterface_nodeid_ipaddr_ismanaged_idx
|-
| ipstatus
|
| null
|
|
|
|-
| iplastcapsdpoll
|
| null
|
|
|
|-
| issnmpprimary
|
| null
|
|
|
|-
| snmpinterfaceid
|
| null
|
|
| ipinterface_snmpinterfaceid_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.snmpinterface_(table)|public.snmpinterface]]
| snmpinterfaceid
| id
|}

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

|-
| [[public.ifservices_(table)|public.ifservices]]
| id
| ipinterfaceid
|}

@@ Line 113: / Line 113: @@
 |- valign="top"
 | ipinterface_nodeid_ipaddr_notzero_idx
-| Unique
 | nodeid, ipaddr
 |- valign="top"
@@ Line 155: / Line 155: @@
 |- valign="top"
 | setsnmpinterfacekeysoninserttrigger
-| ROW BEFORE INSERT
+| STATEMENT AFTER
 | setsnmpinterfacekeysoninsert
 |- valign="top"
 | setsnmpinterfacekeysonupdatetrigger
-| ROW BEFORE UPDATE
+| STATEMENT AFTER
 | setsnmpinterfacekeysonupdate
 |}

@@ Line 20: / Line 20: @@
 | integer
 | not null
-| nextval('opennmsnxtid'::regclass)
+|
 |- valign="top"
@@ Line 95: / Line 95: @@
 | '''Columns
 |- valign="top"
 | ipinterface_ipaddr_idx
@@ Line 123: / Line 111: @@
+|
 | nodeid, ipaddr, ismanaged
 |}
@@ Line 140: / Line 140: @@
 | snmpinterfaceid
 | id
 |- valign="top"
-| [[public.ifservices_(table)|public.ifservices]]
+| [[public.ipinterface_(table)|public.ipinterface]]
 | 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 50: / Line 46: @@
 | varchar(256)
 | null
+|
+|
@@ Line 59: / Line 54: @@
+|
+|
 |-
 | ipstatus
 | integer
 | null
+|
+|
@@ Line 71: / Line 64: @@
 | timestamp with time zone
 | null
+|
+|
@@ Line 78: / Line 70: @@
 | char(1)
 | null
+|
+|
@@ Line 87: / Line 78: @@
+|
+|
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 108: / Line 144: @@
 |}
+=== Detail Tables ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 122: / Line 158: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 136: / Line 173: @@
 | ROW BEFORE UPDATE
 | setsnmpinterfacekeysonupdate
 |}

@@ Line 130: / Line 130: @@
 |-
 | setsnmpinterfacekeysoninserttrigger
-| ROWBEFORE INSERT
+| ROW BEFORE INSERT
 | setsnmpinterfacekeysoninsert
 |-
 | setsnmpinterfacekeysonupdatetrigger
-| ROWBEFORE UPDATE
+| ROW BEFORE UPDATE
 | setsnmpinterfacekeysonupdate
 |}

@@ Line 119: / Line 119: @@
 | id
 | ipinterfaceid
 |}