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

From dbscript Online Help
Jump to: navigation, search
Line 143: Line 143:
 
| '''Columns
 
| '''Columns
  
 +
|- valign="top"
 +
| node_dpname_idx
 +
|
 +
| dpname
 
|- valign="top"
 
|- valign="top"
 
| node_foreign_unique_idx
 
| node_foreign_unique_idx
 
| Unique
 
| Unique
 
| foreignsource, foreignid
 
| foreignsource, foreignid
−
|- valign="top"
 
−
| node_dpname_idx
 
−
|
 
−
| dpname
 
 
|- valign="top"
 
|- valign="top"
 
| node_id_type_idx
 
| node_id_type_idx
Line 172: Line 172:
 
| dpname
 
| dpname
 
| dpname
 
| dpname
−
|}
 
−
 
−
=== Detail Tables ===
 
−
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
−
|- style="background:silver"
 
−
| '''Detail Table
 
−
| '''Column
 
−
| '''Referencing Column
 
−
 
 
|- valign="top"
 
|- valign="top"
−
| [[public.atinterface_(table)|public.atinterface]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|- valign="top"
 
|- valign="top"
−
| [[public.stpnode_(table)|public.stpnode]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|- valign="top"
 
|- valign="top"
−
| [[public.stpinterface_(table)|public.stpinterface]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|- valign="top"
 
|- valign="top"
−
| [[public.iprouteinterface_(table)|public.iprouteinterface]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|- valign="top"
 
|- valign="top"
−
| [[public.datalinkinterface_(table)|public.datalinkinterface]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|- valign="top"
 
|- valign="top"
−
| [[public.datalinkinterface_(table)|public.datalinkinterface]]
+
| [[public.node_(table)|public.node]]
 +
| nodeparentid
 
| nodeid
 
| nodeid
−
| nodeparentid
 
 
|- valign="top"
 
|- valign="top"
−
| [[public.inventory_(table)|public.inventory]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|- valign="top"
 
|- valign="top"
−
| [[public.vlan_(table)|public.vlan]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|- valign="top"
 
|- valign="top"
−
| [[public.ipinterface_(table)|public.ipinterface]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|- valign="top"
 
|- valign="top"
−
| [[public.snmpinterface_(table)|public.snmpinterface]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|- valign="top"
 
|- valign="top"
−
| [[public.ifservices_(table)|public.ifservices]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|- valign="top"
 
|- valign="top"
−
| [[public.outages_(table)|public.outages]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|- valign="top"
 
|- valign="top"
−
| [[public.assets_(table)|public.assets]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|- valign="top"
 
|- valign="top"
−
| [[public.notifications_(table)|public.notifications]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|- valign="top"
 
|- valign="top"
−
| [[public.pathoutage_(table)|public.pathoutage]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|- valign="top"
 
|- valign="top"
−
| [[public.category_node_(table)|public.category_node]]
+
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid

Revision as of 10:09, 27 August 2011

wikibot

Table public.node

Columns

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

Primary Key Columns
pk_nodeid nodeid

Indexes

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

Foreign Keys

Relation Column Referenced Column
public.distpoller dpname dpname
public.node nodeid nodeid
public.node nodeid nodeid
public.node nodeid nodeid
public.node nodeid nodeid
public.node nodeid nodeid
public.node nodeparentid nodeid
public.node nodeid nodeid
public.node nodeid nodeid
public.node nodeid nodeid
public.node nodeid nodeid
public.node nodeid nodeid
public.node nodeid nodeid
public.node nodeid nodeid
public.node nodeid nodeid
public.node nodeid nodeid
public.node nodeid nodeid

Dependencies

Reference Type Object Type Referencing Object
Select Function public.getmanagedoutagefornodeinwindow
Retrieved from "http://dbshelp.devio.at/index.php?title=Public.node_(table)&oldid=2963"