Public.node (table)

From dbscript Online Help
Revision as of 10:25, 27 August 2011 by Bot (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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