Difference between revisions of "Public.assets (table)"
(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 14: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 |
