Difference between revisions of "Public.assets (table)"
| Line 9: | Line 9: | ||
| + | === 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 16: | ||
| '''Nullable | | '''Nullable | ||
| '''Default | | '''Default | ||
| − | | ''' | + | | '''Description |
| − | |||
|- | |- | ||
| Line 23: | Line 23: | ||
| not null | | not null | ||
| nextval('opennmsnxtid'::regclass) | | nextval('opennmsnxtid'::regclass) | ||
| − | |||
| | | | ||
|- | |- | ||
| Line 31: | Line 30: | ||
| | | | ||
| | | | ||
| − | |||
|- | |- | ||
| category | | category | ||
| varchar(64) | | varchar(64) | ||
| not null | | not null | ||
| − | |||
| | | | ||
| | | | ||
| Line 43: | Line 40: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 50: | Line 46: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 57: | Line 52: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 64: | Line 58: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 71: | Line 64: | ||
| varchar(128) | | varchar(128) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 78: | Line 70: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 87: | Line 78: | ||
| | | | ||
| | | | ||
| − | |||
|- | |- | ||
| operatingsystem | | operatingsystem | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 99: | Line 88: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 106: | Line 94: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 113: | Line 100: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 120: | Line 106: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 127: | Line 112: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 134: | Line 118: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 141: | Line 124: | ||
| varchar(256) | | varchar(256) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 148: | Line 130: | ||
| varchar(256) | | varchar(256) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 155: | Line 136: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 162: | Line 142: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 169: | Line 148: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 176: | Line 154: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 183: | Line 160: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 190: | Line 166: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 197: | Line 172: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 204: | Line 178: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 211: | Line 184: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 218: | Line 190: | ||
| char(20) | | char(20) | ||
| not null | | not null | ||
| − | |||
| | | | ||
| | | | ||
| Line 225: | Line 196: | ||
| timestamp with time zone | | timestamp with time zone | ||
| not null | | not null | ||
| − | |||
| | | | ||
| | | | ||
| Line 232: | Line 202: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 239: | Line 208: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 246: | Line 214: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 253: | Line 220: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 260: | Line 226: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 267: | Line 232: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 274: | Line 238: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 281: | Line 244: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 288: | Line 250: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 295: | Line 256: | ||
| varchar(64) | | varchar(64) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 302: | Line 262: | ||
| text | | text | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 309: | Line 268: | ||
| varchar(512) | | varchar(512) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
| Line 316: | Line 274: | ||
| varchar(512) | | varchar(512) | ||
| null | | null | ||
| − | |||
| | | | ||
| | | | ||
|} | |} | ||
| + | === Primary Key === | ||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- style="background:silver" | ||
| + | | '''Primary Key | ||
| + | | '''Columns | ||
| + | |- | ||
| + | | pk_assetid | ||
| + | | id | ||
| + | |} | ||
| + | === Indexes === | ||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- style="background:silver" | ||
| + | | '''Index | ||
| + | | '''Type | ||
| + | | '''Columns | ||
| + | |||
| + | |- | ||
| + | | assets_nodeid_idx | ||
| + | | | ||
| + | | nodeid | ||
| + | |- | ||
| + | | assets_an_idx | ||
| + | | | ||
| + | | assetnumber | ||
| + | |} | ||
| + | === 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" | ||
Revision as of 09:31, 11 February 2010
wikibot
| Table | public.assets |
Columns
| Column | Data Type | Nullable | Default | Description |
| id | integer | not null | nextval('opennmsnxtid'::regclass) | |
| 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_nodeid_idx | nodeid | |
| assets_an_idx | assetnumber |
Foreign Keys
| Relation | Column | Referenced Column |
| public.node | nodeid | nodeid |
