public assets (table)

wikibot ¶

Table

public.assets

Columns ¶

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 ¶

Primary Key	Columns
pk_assetid	id

Indexes ¶

Index	Type	Columns
assets_an_idx		assetnumber
assets_nodeid_idx		nodeid

Foreign Keys ¶

Relation	Column	Referenced Column
public.node	nodeid	nodeid