Public.assets (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table public.assets

Columns[edit]

Column Data Type Nullable Default Description
id integer not null
nodeid integer null
category varchar(64) not null
manufacturer varchar(64) null
vendor varchar(64) null
modelnumber varchar(64) null
serialnumber varchar(64) null
description varchar(128) null
circuitid varchar(64) null
assetnumber varchar(64) null
operatingsystem varchar(64) null
rack varchar(64) null
slot varchar(64) null
port varchar(64) null
region varchar(64) null
division varchar(64) null
department varchar(64) null
address1 varchar(256) null
address2 varchar(256) null
city varchar(64) null
state varchar(64) null
zip varchar(64) null
building varchar(64) null
floor varchar(64) null
room varchar(64) null
vendorphone varchar(64) null
vendorfax varchar(64) null
vendorassetnumber varchar(64) null
userlastmodified char(20) not null
lastmodifieddate timestamp with time zone not null
dateinstalled varchar(64) null
lease varchar(64) null
leaseexpires varchar(64) null
supportphone varchar(64) null
maintcontract varchar(64) null
maintcontractexpires varchar(64) null
displaycategory varchar(64) null
notifycategory varchar(64) null
pollercategory varchar(64) null
thresholdcategory varchar(64) null
comment text null
managedobjectinstance varchar(512) null
managedobjecttype varchar(512) null

Primary Key[edit]

Primary Key Columns
pk_assetid id

Indexes[edit]

Index Type Columns
assets_an_idx assetnumber
assets_nodeid_idx nodeid

Foreign Keys[edit]

Relation Column Referenced Column
public.node nodeid nodeid