Public.assets (table)

wikibot

Table

public.assets

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