Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Back
public assets (table)
Modified on 2011/08/27 11:43
by
wikibot
Categorized as
Uncategorized
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | public.assets |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | id | integer | not null | | |- valign="top" | nodeid | integer | null | | |- valign="top" | category | varchar(64) | not null | | |- valign="top" | manufacturer | varchar(64) | null | | |- valign="top" | vendor | varchar(64) | null | | |- valign="top" | modelnumber | varchar(64) | null | | |- valign="top" | serialnumber | varchar(64) | null | | |- valign="top" | description | varchar(128) | null | | |- valign="top" | circuitid | varchar(64) | null | | |- valign="top" | assetnumber | varchar(64) | null | | |- valign="top" | operatingsystem | varchar(64) | null | | |- valign="top" | rack | varchar(64) | null | | |- valign="top" | slot | varchar(64) | null | | |- valign="top" | port | varchar(64) | null | | |- valign="top" | region | varchar(64) | null | | |- valign="top" | division | varchar(64) | null | | |- valign="top" | department | varchar(64) | null | | |- valign="top" | address1 | varchar(256) | null | | |- valign="top" | address2 | varchar(256) | null | | |- valign="top" | city | varchar(64) | null | | |- valign="top" | state | varchar(64) | null | | |- valign="top" | zip | varchar(64) | null | | |- valign="top" | building | varchar(64) | null | | |- valign="top" | floor | varchar(64) | null | | |- valign="top" | room | varchar(64) | null | | |- valign="top" | vendorphone | varchar(64) | null | | |- valign="top" | vendorfax | varchar(64) | null | | |- valign="top" | vendorassetnumber | varchar(64) | null | | |- valign="top" | userlastmodified | char(20) | not null | | |- valign="top" | lastmodifieddate | timestamp with time zone | not null | | |- valign="top" | dateinstalled | varchar(64) | null | | |- valign="top" | lease | varchar(64) | null | | |- valign="top" | leaseexpires | varchar(64) | null | | |- valign="top" | supportphone | varchar(64) | null | | |- valign="top" | maintcontract | varchar(64) | null | | |- valign="top" | maintcontractexpires | varchar(64) | null | | |- valign="top" | displaycategory | varchar(64) | null | | |- valign="top" | notifycategory | varchar(64) | null | | |- valign="top" | pollercategory | varchar(64) | null | | |- valign="top" | thresholdcategory | varchar(64) | null | | |- valign="top" | comment | text | null | | |- valign="top" | managedobjectinstance | varchar(512) | null | | |- valign="top" | managedobjecttype | varchar(512) | 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" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- valign="top" | [[public node (table)|public.node]] | nodeid | nodeid |}
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.