From dbscript Online Help
wikibot
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
Detail Tables