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
