Table webco_3.6.1.public.resource_ext Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
obj_oid serial 10  √  nextval('resource_ext_obj_oid_seq'::regclass)
container_foreignid varchar 2147483647  √  null
foreignrtypeid varchar 2147483647  √  null
metaclass varchar 2147483647  √  null
file_id varchar 2147483647  √  null
csv_line_number int4 10  √  null
origin varchar 2147483647  √  null
accessories varchar 2147483647  √  null
asset_tag varchar 2147483647  √  null
barcode varchar 2147483647  √  null
capacity varchar 2147483647  √  null
circulating varchar 2147483647  √  null
condition_note varchar 2147483647  √  null
description varchar 2147483647  √  null
destination varchar 2147483647  √  null
label_id varchar 2147483647  √  null
inventory_date varchar 2147483647  √  null
location varchar 2147483647  √  null
manufacturer varchar 2147483647  √  null
model varchar 2147483647  √  null
purchase_date varchar 2147483647  √  null
purchase_order varchar 2147483647  √  null
replacement_date varchar 2147483647  √  null
room_number varchar 2147483647  √  null
serial_number varchar 2147483647  √  null
unserialized varchar 2147483647  √  null
url varchar 2147483647  √  null
value varchar 2147483647  √  null
vendor varchar 2147483647  √  null
warranty_labor varchar 2147483647  √  null
warranty_parts varchar 2147483647  √  null
biblio_id varchar 2147483647  √  null
call_number varchar 2147483647  √  null
restrictions varchar 2147483647  √  null
home_location_string varchar 2147483647  √  null
distributor varchar 2147483647  √  null
shelf_location varchar 2147483647  √  null

Table contained 0 rows at Wed May 11 15:14 EDT 2011