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...)
 
Line 20: Line 20:
 
|-
 
|-
 
| id
 
| id
−
|  
+
| integer
 
| not null
 
| not null
 
| nextval('opennmsnxtid'::regclass)
 
| nextval('opennmsnxtid'::regclass)
Line 27: Line 27:
 
|-
 
|-
 
| nodeid
 
| nodeid
−
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 34: Line 34:
 
|-
 
|-
 
| category
 
| category
−
|  
+
| varchar(64)
 
| not null
 
| not null
 
|  
 
|  
Line 41: Line 41:
 
|-
 
|-
 
| manufacturer
 
| manufacturer
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 48: Line 48:
 
|-
 
|-
 
| vendor
 
| vendor
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 55: Line 55:
 
|-
 
|-
 
| modelnumber
 
| modelnumber
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 62: Line 62:
 
|-
 
|-
 
| serialnumber
 
| serialnumber
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 69: Line 69:
 
|-
 
|-
 
| description
 
| description
−
|  
+
| varchar(128)
 
| null
 
| null
 
|  
 
|  
Line 76: Line 76:
 
|-
 
|-
 
| circuitid
 
| circuitid
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 83: Line 83:
 
|-
 
|-
 
| assetnumber
 
| assetnumber
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 90: Line 90:
 
|-
 
|-
 
| operatingsystem
 
| operatingsystem
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 97: Line 97:
 
|-
 
|-
 
| rack
 
| rack
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 104: Line 104:
 
|-
 
|-
 
| slot
 
| slot
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 111: Line 111:
 
|-
 
|-
 
| port
 
| port
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 118: Line 118:
 
|-
 
|-
 
| region
 
| region
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 125: Line 125:
 
|-
 
|-
 
| division
 
| division
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 132: Line 132:
 
|-
 
|-
 
| department
 
| department
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 139: Line 139:
 
|-
 
|-
 
| address1
 
| address1
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
Line 146: Line 146:
 
|-
 
|-
 
| address2
 
| address2
−
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
Line 153: Line 153:
 
|-
 
|-
 
| city
 
| city
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 160: Line 160:
 
|-
 
|-
 
| state
 
| state
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 167: Line 167:
 
|-
 
|-
 
| zip
 
| zip
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 174: Line 174:
 
|-
 
|-
 
| building
 
| building
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 181: Line 181:
 
|-
 
|-
 
| floor
 
| floor
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 188: Line 188:
 
|-
 
|-
 
| room
 
| room
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 195: Line 195:
 
|-
 
|-
 
| vendorphone
 
| vendorphone
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 202: Line 202:
 
|-
 
|-
 
| vendorfax
 
| vendorfax
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 209: Line 209:
 
|-
 
|-
 
| vendorassetnumber
 
| vendorassetnumber
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 216: Line 216:
 
|-
 
|-
 
| userlastmodified
 
| userlastmodified
−
|  
+
| char(20)
 
| not null
 
| not null
 
|  
 
|  
Line 223: Line 223:
 
|-
 
|-
 
| lastmodifieddate
 
| lastmodifieddate
−
|  
+
| timestamp with time zone
 
| not null
 
| not null
 
|  
 
|  
Line 230: Line 230:
 
|-
 
|-
 
| dateinstalled
 
| dateinstalled
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 237: Line 237:
 
|-
 
|-
 
| lease
 
| lease
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 244: Line 244:
 
|-
 
|-
 
| leaseexpires
 
| leaseexpires
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 251: Line 251:
 
|-
 
|-
 
| supportphone
 
| supportphone
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 258: Line 258:
 
|-
 
|-
 
| maintcontract
 
| maintcontract
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 265: Line 265:
 
|-
 
|-
 
| maintcontractexpires
 
| maintcontractexpires
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 272: Line 272:
 
|-
 
|-
 
| displaycategory
 
| displaycategory
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 279: Line 279:
 
|-
 
|-
 
| notifycategory
 
| notifycategory
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 286: Line 286:
 
|-
 
|-
 
| pollercategory
 
| pollercategory
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 293: Line 293:
 
|-
 
|-
 
| thresholdcategory
 
| thresholdcategory
−
|  
+
| varchar(64)
 
| null
 
| null
 
|  
 
|  
Line 300: Line 300:
 
|-
 
|-
 
| comment
 
| comment
−
|  
+
| text
 
| null
 
| null
 
|  
 
|  
Line 307: Line 307:
 
|-
 
|-
 
| managedobjectinstance
 
| managedobjectinstance
−
|  
+
| varchar(512)
 
| null
 
| null
 
|  
 
|  
Line 314: Line 314:
 
|-
 
|-
 
| managedobjecttype
 
| managedobjecttype
−
|  
+
| varchar(512)
 
| null
 
| null
 
|  
 
|  

Revision as of 15:42, 7 August 2009

wikibot

Table public.assets


Column Data Type Nullable Default PK Index
id integer not null nextval('opennmsnxtid'::regclass) pk_assetid
nodeid integer null assets_nodeid_idx
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 assets_an_idx
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


Relation Column Referenced Column
public.node nodeid nodeid
Retrieved from "http://dbshelp.devio.at/index.php?title=Public.assets_(table)&oldid=731"