From dbscript Online Help
wikibot
Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
id
|
|
not null
|
nextval('opennmsnxtid'::regclass)
|
pk_assetid
|
|
nodeid
|
|
null
|
|
|
assets_nodeid_idx
|
category
|
|
not null
|
|
|
|
manufacturer
|
|
null
|
|
|
|
vendor
|
|
null
|
|
|
|
modelnumber
|
|
null
|
|
|
|
serialnumber
|
|
null
|
|
|
|
description
|
|
null
|
|
|
|
circuitid
|
|
null
|
|
|
|
assetnumber
|
|
null
|
|
|
assets_an_idx
|
operatingsystem
|
|
null
|
|
|
|
rack
|
|
null
|
|
|
|
slot
|
|
null
|
|
|
|
port
|
|
null
|
|
|
|
region
|
|
null
|
|
|
|
division
|
|
null
|
|
|
|
department
|
|
null
|
|
|
|
address1
|
|
null
|
|
|
|
address2
|
|
null
|
|
|
|
city
|
|
null
|
|
|
|
state
|
|
null
|
|
|
|
zip
|
|
null
|
|
|
|
building
|
|
null
|
|
|
|
floor
|
|
null
|
|
|
|
room
|
|
null
|
|
|
|
vendorphone
|
|
null
|
|
|
|
vendorfax
|
|
null
|
|
|
|
vendorassetnumber
|
|
null
|
|
|
|
userlastmodified
|
|
not null
|
|
|
|
lastmodifieddate
|
|
not null
|
|
|
|
dateinstalled
|
|
null
|
|
|
|
lease
|
|
null
|
|
|
|
leaseexpires
|
|
null
|
|
|
|
supportphone
|
|
null
|
|
|
|
maintcontract
|
|
null
|
|
|
|
maintcontractexpires
|
|
null
|
|
|
|
displaycategory
|
|
null
|
|
|
|
notifycategory
|
|
null
|
|
|
|
pollercategory
|
|
null
|
|
|
|
thresholdcategory
|
|
null
|
|
|
|
comment
|
|
null
|
|
|
|
managedobjectinstance
|
|
null
|
|
|
|
managedobjecttype
|
|
null
|
|
|
|
Relation
|
Column
|
Referenced Column
|
public.node
|
nodeid
|
nodeid
|