Public.node (table)

From dbscript Online Help
Revision as of 10:19, 27 August 2011 by Bot (talk | contribs)
Jump to: navigation, search

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 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