Table webco_4.3.3.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_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
resource.containing_resource_oid fkres_cont_res
resource.location_resource_oid fkcres_loc_res
resource_schedule.scheduled_resource_oid fkcresource_schedule_scheduled_resource_oid
ticket.resource_oid fkticket_res
wco_group.facility_oid fkcwco_group_facility_oid
modified timestamptz 35,6  √  null
deleted bool 1 false
origin varchar 2147483647
foreignid varchar 2147483647  √  null
label_id varchar 2147483647
metaclass wcof_tag 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
assigned_person_oid int8 19  √  null
person.obj_oid fkcres_person
value odcl_money 2147483647  √  null
aggregate_value odcl_money 2147483647  √  null
location_note varchar 2147483647  √  null
destination bool 1  √  null
accessories _varchar 2147483647 ARRAY[]::character varying[]
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 timestamptz 35,6  √  null
room_number varchar 2147483647  √  null
capacity int4 10  √  null
max_quantity int4 10  √  null
roles _varchar 2147483647 ARRAY[]::character varying[]
purchase_order varchar 2147483647  √  null
purchase_note varchar 2147483647  √  null
asset_tag varchar 2147483647  √  null
replacement_date timestamptz 35,6  √  null
last_inventoried_date timestamptz 35,6  √  null
hostname varchar 2147483647  √  null
hardware_version varchar 2147483647  √  null
software_version varchar 2147483647  √  null
ip_address varchar 2147483647  √  null
mac_address varchar 2147483647  √  null
budget_number varchar 2147483647  √  null
previous_allocation_oid int8 19  √  null
current_allocation_oid int8 19  √  null
next_allocation_oid int8 19  √  null

Table contained 0 rows at Fri Sep 23 14:49 CDT 2016

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  
unserialized Performance Asc resource_unserialized_idx  
rtype_oid Performance Asc rtype_oid_idx  

Close relationships  within of separation: