Public.node (table) - Revision history

Bot at 09:25, 27 August 2011

2011-08-27T09:25:14Z

Bot at 09:19, 27 August 2011

2011-08-27T09:19:50Z

Bot at 09:09, 27 August 2011

2011-08-27T09:09:40Z

Bot at 22:39, 24 June 2010

2010-06-24T22:39:08Z

Show changes

Bot at 07:32, 11 February 2010

2010-02-11T07:32:04Z

Bot at 13:43, 7 August 2009

2009-08-07T13:43:22Z

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

2009-08-07T13:14:20Z

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

New page

== wikibot ==

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

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

|-
| nodeid
|
| not null
|
| pk_nodeid
| node_id_type_idx
|-
| dpname
|
| null
|
|
| node_dpname_idx
|-
| nodecreatetime
|
| not null
|
|
|
|-
| nodeparentid
|
| null
|
|
|
|-
| nodetype
|
| null
|
|
| node_id_type_idx
|-
| nodesysoid
|
| null
|
|
|
|-
| nodesysname
|
| null
|
|
|
|-
| nodesysdescription
|
| null
|
|
|
|-
| nodesyslocation
|
| null
|
|
|
|-
| nodesyscontact
|
| null
|
|
|
|-
| nodelabel
|
| null
|
|
| node_label_idx
|-
| nodelabelsource
|
| null
|
|
|
|-
| nodenetbiosname
|
| null
|
|
|
|-
| nodedomainname
|
| null
|
|
|
|-
| operatingsystem
|
| null
|
|
|
|-
| lastcapsdpoll
|
| null
|
|
|
|-
| foreignsource
|
| null
|
|
| node_foreign_unique_idx
|-
| foreignid
|
| null
|
|
| node_foreign_unique_idx
|}

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

|-
| [[public.distpoller_(table)|public.distpoller]]
| dpname
| dpname
|}

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

|-
| [[public.atinterface_(table)|public.atinterface]]
| nodeid
| nodeid
|-
| [[public.stpnode_(table)|public.stpnode]]
| nodeid
| nodeid
|-
| [[public.stpinterface_(table)|public.stpinterface]]
| nodeid
| nodeid
|-
| [[public.iprouteinterface_(table)|public.iprouteinterface]]
| nodeid
| nodeid
|-
| [[public.datalinkinterface_(table)|public.datalinkinterface]]
| nodeid
| nodeid
|-
| [[public.datalinkinterface_(table)|public.datalinkinterface]]
| nodeid
| nodeparentid
|-
| [[public.inventory_(table)|public.inventory]]
| nodeid
| nodeid
|-
| [[public.vlan_(table)|public.vlan]]
| nodeid
| nodeid
|-
| [[public.ipinterface_(table)|public.ipinterface]]
| nodeid
| nodeid
|-
| [[public.snmpinterface_(table)|public.snmpinterface]]
| nodeid
| nodeid
|-
| [[public.ifservices_(table)|public.ifservices]]
| nodeid
| nodeid
|-
| [[public.outages_(table)|public.outages]]
| nodeid
| nodeid
|-
| [[public.assets_(table)|public.assets]]
| nodeid
| nodeid
|-
| [[public.notifications_(table)|public.notifications]]
| nodeid
| nodeid
|-
| [[public.pathoutage_(table)|public.pathoutage]]
| nodeid
| nodeid
|-
| [[public.category_node_(table)|public.category_node]]
| nodeid
| nodeid
|}

@@ Line 149: / Line 149: @@
 |- valign="top"
 | node_foreign_unique_idx
-| Unique
 | foreignsource, foreignid
 |- valign="top"
@@ Line 236: / Line 236: @@
 | nodeid
 | nodeid
 |}

@@ 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
+|
-| pk_nodeid
 |-
 | dpname
@@ Line 31: / Line 30: @@
+|
+|
 |-
 | nodecreatetime
 | timestamp with time zone
 | not null
+|
+|
@@ Line 43: / Line 40: @@
 | integer
 | null
+|
+|
@@ Line 52: / Line 48: @@
+|
+|
 |-
 | nodesysoid
 | varchar(256)
 | null
+|
+|
@@ Line 64: / Line 58: @@
 | varchar(256)
 | null
+|
+|
@@ Line 71: / Line 64: @@
 | varchar(256)
 | null
+|
+|
@@ Line 78: / Line 70: @@
 | varchar(256)
 | null
+|
+|
@@ Line 85: / Line 76: @@
 | varchar(256)
 | null
+|
+|
@@ Line 94: / Line 84: @@
+|
+|
 |-
 | nodelabelsource
 | char(1)
 | null
+|
+|
@@ Line 106: / Line 94: @@
 | varchar(16)
 | null
+|
+|
@@ Line 113: / Line 100: @@
 | varchar(16)
 | null
+|
+|
@@ Line 120: / Line 106: @@
 | varchar(64)
 | null
+|
+|
@@ Line 127: / Line 112: @@
 | timestamp with time zone
 | null
+|
+|
@@ Line 136: / Line 120: @@
+|
+|
 |-
 | foreignid
@@ Line 143: / Line 126: @@
+|
+|
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 160: / Line 176: @@
 |}
+=== Detail Tables ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 231: / Line 247: @@
 | nodeid
 | nodeid
 |}

@@ Line 20: / Line 20: @@
 |-
 | nodeid
+| integer
 | not null
+|
@@ Line 27: / Line 27: @@
 |-
 | dpname
+| varchar(12)
 | null
+|
@@ Line 34: / Line 34: @@
 |-
 | nodecreatetime
+| timestamp with time zone
 | not null
+|
@@ Line 41: / Line 41: @@
 |-
 | nodeparentid
+| integer
 | null
+|
@@ Line 48: / Line 48: @@
 |-
 | nodetype
+| char(1)
 | null
+|
@@ Line 55: / Line 55: @@
 |-
 | nodesysoid
+| varchar(256)
 | null
+|
@@ Line 62: / Line 62: @@
 |-
 | nodesysname
+| varchar(256)
 | null
+|
@@ Line 69: / Line 69: @@
 |-
 | nodesysdescription
+| varchar(256)
 | null
+|
@@ Line 76: / Line 76: @@
 |-
 | nodesyslocation
+| varchar(256)
 | null
+|
@@ Line 83: / Line 83: @@
 |-
 | nodesyscontact
+| varchar(256)
 | null
+|
@@ Line 90: / Line 90: @@
 |-
 | nodelabel
+| varchar(256)
 | null
+|
@@ Line 97: / Line 97: @@
 |-
 | nodelabelsource
+| char(1)
 | null
+|
@@ Line 104: / Line 104: @@
 |-
 | nodenetbiosname
+| varchar(16)
 | null
+|
@@ Line 111: / Line 111: @@
 |-
 | nodedomainname
+| varchar(16)
 | null
+|
@@ Line 118: / Line 118: @@
 |-
 | operatingsystem
+| varchar(64)
 | null
+|
@@ Line 125: / Line 125: @@
 |-
 | lastcapsdpoll
+| timestamp with time zone
 | null
+|
@@ Line 132: / Line 132: @@
 |-
 | foreignsource
+| varchar(64)
 | null
+|
@@ Line 139: / Line 139: @@
 |-
 | foreignid
+| varchar(64)
 | null
+|