Table webco_4.7.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 int8 19
origin varchar 2147483647
container_unique_identifier varchar 2147483647  √  null
resource_type_unique_identifier varchar 2147483647  √  null
metaclass varchar 2147483647  √  null
file_id varchar 2147483647  √  null
csv_line_number int4 10  √  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
checkout_center 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
location_note varchar 2147483647  √  null
mac_address varchar 2147483647  √  null
hostname varchar 2147483647  √  null
hardware_version varchar 2147483647  √  null
software_version varchar 2147483647  √  null
ip_address varchar 2147483647  √  null
budget_number varchar 2147483647  √  null
assigned_person varchar 2147483647  √  null
assigned_department varchar 2147483647  √  null

Table contained 0 rows at Thu Feb 14 09:20 CST 2019

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc resource_ext_pkey