Table webco_3.9.1.public.resource 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
allocation.deliver_to_oid fkcalloc_deliver_to_oid
allocation_building_pass.resource_oid fkcalloc_building_pass_resource_oid
allocation_route.sink_oid allocation_route_sink_oid_fkey
allocation_route.source_oid allocation_route_source_oid_fkey
holding.resource_oid fkholding_resource
inventory_event.resource_oid inventory_event_resource_oid_fkey
invoice_line.resource_oid fkinv_line_res
pir_item.resource_oid fkcpir_item_resource_oid
resource.containing_resource_oid fkres_cont_res
resource.location_resource_oid fkcres_loc_res
resource_schedule.scheduled_resource_oid resource_schedule_scheduled_resource_oid_fkey
ticket.resource_oid fkticket_res
wco_group.facility_oid fkcwco_group_facility_oid
modified timestamp 29,6  √  null
deleted bool 1 false
origin varchar 2147483647  √  null
foreignid varchar 2147483647  √  null
label_id varchar 2147483647  √  null
metaclass varchar 2147483647
circulating bool 1  √  null
unserialized bool 1  √  null
barcode varchar 2147483647  √  null
rtype_oid int8 19
resource_type.obj_oid resource_rtype_oid_fkey
containing_resource_oid int8 19  √  null
resource.obj_oid fkres_cont_res
location_resource_oid int8 19  √  null
resource.obj_oid fkcres_loc_res
location_oid int8 19
location.obj_oid resource_location_oid_fkey
value int8 19  √  null
aggregate_value int8 19  √  null
destination bool 1  √  null
accessories varchar 2147483647  √  null
condition_note varchar 2147483647  √  null
description varchar 2147483647  √  null
url varchar 2147483647  √  null
manufacturer varchar 2147483647  √  null
model varchar 2147483647  √  null
serial_number varchar 2147483647  √  null
warranty_labor varchar 2147483647  √  null
warranty_parts varchar 2147483647  √  null
vendor varchar 2147483647  √  null
purchase_date timestamp 29,6  √  null
room_number varchar 2147483647  √  null
capacity int4 10  √  null
max_quantity int4 10  √  null
roles varchar 2147483647  √  null
purchase_order varchar 2147483647  √  null
asset_tag varchar 2147483647  √  null
replacement_date timestamp 29,6  √  null
last_inventoried_date timestamp 29,6  √  null
mac_address varchar 2147483647  √  null
home_location_path varchar 2147483647  √  null
budget_number varchar 2147483647  √  null

Table contained 0 rows at Tue Feb 04 14:58 EST 2014

Indexes:
Column(s) Type Sort Constraint Name Anomalies
obj_oid Primary key Asc resource_pkey  
barcode Must be unique Asc resource_barcode_key This unique column is also nullable
foreignid Must be unique Asc resource_foreignid_key This unique column is also nullable
label_id Must be unique Asc resource_label_id_key This unique column is also nullable
unserialized Performance Asc resource_unserialized_idx  
rtype_oid Performance Asc rtype_oid_idx  

Close relationships  within of separation: