Difference between revisions of "Public.node (table)"

From dbscript Online Help
Jump to: navigation, search
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| public.node
 
| public.node
−
|-
 
 
|}
 
|}
−
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
−
+
 
−
|-
+
|- valign="top"
 
| nodeid
 
| nodeid
 
| integer
 
| integer
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| dpname
 
| dpname
 
| varchar(12)
 
| varchar(12)
Line 30: Line 28:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodecreatetime
 
| nodecreatetime
 
| timestamp with time zone
 
| timestamp with time zone
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodeparentid
 
| nodeparentid
 
| integer
 
| integer
Line 42: Line 40:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodetype
 
| nodetype
 
| char(1)
 
| char(1)
Line 48: Line 46:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodesysoid
 
| nodesysoid
 
| varchar(256)
 
| varchar(256)
Line 54: Line 52:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodesysname
 
| nodesysname
 
| varchar(256)
 
| varchar(256)
Line 60: Line 58:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodesysdescription
 
| nodesysdescription
 
| varchar(256)
 
| varchar(256)
Line 66: Line 64:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodesyslocation
 
| nodesyslocation
 
| varchar(256)
 
| varchar(256)
Line 72: Line 70:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodesyscontact
 
| nodesyscontact
 
| varchar(256)
 
| varchar(256)
Line 78: Line 76:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodelabel
 
| nodelabel
 
| varchar(256)
 
| varchar(256)
Line 84: Line 82:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodelabelsource
 
| nodelabelsource
 
| char(1)
 
| char(1)
Line 90: Line 88:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodenetbiosname
 
| nodenetbiosname
 
| varchar(16)
 
| varchar(16)
Line 96: Line 94:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodedomainname
 
| nodedomainname
 
| varchar(16)
 
| varchar(16)
Line 102: Line 100:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| operatingsystem
 
| operatingsystem
 
| varchar(64)
 
| varchar(64)
Line 108: Line 106:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| lastcapsdpoll
 
| lastcapsdpoll
 
| timestamp with time zone
 
| timestamp with time zone
Line 114: Line 112:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| foreignsource
 
| foreignsource
 
| varchar(64)
 
| varchar(64)
Line 120: Line 118:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| foreignid
 
| foreignid
 
| varchar(64)
 
| varchar(64)
Line 133: Line 131:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
−
|-
+
|- valign="top"
 
| pk_nodeid
 
| pk_nodeid
 
| nodeid
 
| nodeid
Line 144: Line 142:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
−
+
 
−
|-
+
|- valign="top"
−
| node_foreign_unique_idx
 
−
| Unique
 
−
| foreignsource, foreignid
 
−
|-
 
 
| node_dpname_idx
 
| node_dpname_idx
 
|  
 
|  
 
| dpname
 
| dpname
−
|-
+
|- valign="top"
 +
| node_foreign_unique_idx
 +
|
 +
| foreignsource, foreignid
 +
|- valign="top"
 
| node_id_type_idx
 
| node_id_type_idx
 
|  
 
|  
 
| nodeid, nodetype
 
| nodeid, nodetype
−
|-
+
|- valign="top"
 
| node_label_idx
 
| node_label_idx
 
|  
 
|  
Line 169: Line 167:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
+
 
−
|-
+
|- valign="top"
 
| [[public.distpoller_(table)|public.distpoller]]
 
| [[public.distpoller_(table)|public.distpoller]]
 
| dpname
 
| dpname
Line 182: Line 180:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[public.atinterface_(table)|public.atinterface]]
 
| [[public.atinterface_(table)|public.atinterface]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.stpnode_(table)|public.stpnode]]
 
| [[public.stpnode_(table)|public.stpnode]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.stpinterface_(table)|public.stpinterface]]
 
| [[public.stpinterface_(table)|public.stpinterface]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.iprouteinterface_(table)|public.iprouteinterface]]
 
| [[public.iprouteinterface_(table)|public.iprouteinterface]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.datalinkinterface_(table)|public.datalinkinterface]]
 
| [[public.datalinkinterface_(table)|public.datalinkinterface]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.datalinkinterface_(table)|public.datalinkinterface]]
 
| [[public.datalinkinterface_(table)|public.datalinkinterface]]
 
| nodeid
 
| nodeid
 
| nodeparentid
 
| nodeparentid
−
|-
+
|- valign="top"
 
| [[public.inventory_(table)|public.inventory]]
 
| [[public.inventory_(table)|public.inventory]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.vlan_(table)|public.vlan]]
 
| [[public.vlan_(table)|public.vlan]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.ipinterface_(table)|public.ipinterface]]
 
| [[public.ipinterface_(table)|public.ipinterface]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.snmpinterface_(table)|public.snmpinterface]]
 
| [[public.snmpinterface_(table)|public.snmpinterface]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.ifservices_(table)|public.ifservices]]
 
| [[public.ifservices_(table)|public.ifservices]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.outages_(table)|public.outages]]
 
| [[public.outages_(table)|public.outages]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.assets_(table)|public.assets]]
 
| [[public.assets_(table)|public.assets]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.notifications_(table)|public.notifications]]
 
| [[public.notifications_(table)|public.notifications]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.pathoutage_(table)|public.pathoutage]]
 
| [[public.pathoutage_(table)|public.pathoutage]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.category_node_(table)|public.category_node]]
 
| [[public.category_node_(table)|public.category_node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|}
 
−
 
−
 
−
=== Dependencies ===
 
−
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
−
|- style="background:silver"
 
−
| '''Reference Type
 
−
| '''Object Type
 
−
| '''Referencing Object
 
−
 
−
|-
 
−
| Select
 
−
| Function
 
−
| [[public.getmanagedoutagefornodeinwindow_(function)|public.getmanagedoutagefornodeinwindow]]
 
−
 
 
|}
 
|}

Latest revision as of 11:25, 27 August 2011

wikibot[edit]

Table public.node

Columns[edit]

Column Data Type Nullable Default Description
nodeid integer not null
dpname varchar(12) null
nodecreatetime timestamp with time zone not null
nodeparentid integer null
nodetype char(1) null
nodesysoid varchar(256) null
nodesysname varchar(256) null
nodesysdescription varchar(256) null
nodesyslocation varchar(256) null
nodesyscontact varchar(256) null
nodelabel varchar(256) null
nodelabelsource char(1) null
nodenetbiosname varchar(16) null
nodedomainname varchar(16) null
operatingsystem varchar(64) null
lastcapsdpoll timestamp with time zone null
foreignsource varchar(64) null
foreignid varchar(64) null

Primary Key[edit]

Primary Key Columns
pk_nodeid nodeid

Indexes[edit]

Index Type Columns
node_dpname_idx dpname
node_foreign_unique_idx foreignsource, foreignid
node_id_type_idx nodeid, nodetype
node_label_idx nodelabel

Foreign Keys[edit]

Relation Column Referenced Column
public.distpoller dpname dpname

Detail Tables[edit]

Detail Table Column Referencing Column
public.atinterface nodeid nodeid
public.stpnode nodeid nodeid
public.stpinterface nodeid nodeid
public.iprouteinterface nodeid nodeid
public.datalinkinterface nodeid nodeid
public.datalinkinterface nodeid nodeparentid
public.inventory nodeid nodeid
public.vlan nodeid nodeid
public.ipinterface nodeid nodeid
public.snmpinterface nodeid nodeid
public.ifservices nodeid nodeid
public.outages nodeid nodeid
public.assets nodeid nodeid
public.notifications nodeid nodeid
public.pathoutage nodeid nodeid
public.category_node nodeid nodeid
Retrieved from "http://dbshelp.devio.at/index.php?title=Public.node_(table)&oldid=3034"