Difference between revisions of "Public.assets (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.assets |- |} {| border="1" cellpadding="5" cellspacing="0" style="bor...)
 
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| public.assets
 
| public.assets
−
|-
 
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 14:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| id
 
| id
 +
| integer
 +
| not null
 
|  
 
|  
−
| not null
 
−
| nextval('opennmsnxtid'::regclass)
 
−
| pk_assetid
 
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodeid
 
| nodeid
−
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
| assets_nodeid_idx
+
|- valign="top"
−
|-
 
 
| category
 
| category
−
|  
+
| varchar(64)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| manufacturer
 
| manufacturer
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| vendor
 
| vendor
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| modelnumber
 
| modelnumber
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| serialnumber
 
| serialnumber
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| description
 
| description
−
|  
+
| varchar(128)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| circuitid
 
| circuitid
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| assetnumber
 
| assetnumber
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
| assets_an_idx
+
|- valign="top"
−
|-
 
 
| operatingsystem
 
| operatingsystem
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| rack
 
| rack
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| slot
 
| slot
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| port
 
| port
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| region
 
| region
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| division
 
| division
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| department
 
| department
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| address1
 
| address1
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| address2
 
| address2
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| city
 
| city
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| state
 
| state
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| zip
 
| zip
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| building
 
| building
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| floor
 
| floor
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| room
 
| room
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| vendorphone
 
| vendorphone
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| vendorfax
 
| vendorfax
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| vendorassetnumber
 
| vendorassetnumber
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| userlastmodified
 
| userlastmodified
−
|  
+
| char(20)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| lastmodifieddate
 
| lastmodifieddate
−
|  
+
| timestamp with time zone
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| dateinstalled
 
| dateinstalled
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| lease
 
| lease
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| leaseexpires
 
| leaseexpires
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| supportphone
 
| supportphone
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| maintcontract
 
| maintcontract
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| maintcontractexpires
 
| maintcontractexpires
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| displaycategory
 
| displaycategory
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| notifycategory
 
| notifycategory
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| pollercategory
 
| pollercategory
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| thresholdcategory
 
| thresholdcategory
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| comment
 
| comment
−
|  
+
| text
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| managedobjectinstance
 
| managedobjectinstance
−
|  
+
| varchar(512)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| managedobjecttype
 
| managedobjecttype
−
|  
+
| varchar(512)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
 
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| pk_assetid
 +
| id
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| assets_an_idx
 +
|
 +
| assetnumber
 +
|- valign="top"
 +
| assets_nodeid_idx
 +
|
 +
| nodeid
 +
|}
  
 +
=== Foreign Keys ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 328: Line 309:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
+
 
−
|-
+
|- valign="top"
 
| [[public.node_(table)|public.node]]
 
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
 
|}
 
|}

Latest revision as of 11:09, 27 August 2011

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Public.assets_(table)&oldid=2949"