Table webco_5.0.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
holding.resource_oid fkholding_resource
inventory_item.inventoried_home_location_oid inventory_item_inventoried_home_location_oid_fkey
inventory_item.resource_oid inventory_item_resource_oid_fkey
inventory_note.resource_oid inventory_note_resource_oid_fkey
inventory_selector.home_location_oid inventory_selector_home_location_oid_fkey
inventory_selector.resource_oid inventory_selector_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.proposed_resource_oid fkcresource_schedule_proposed_resource_oid
resource_schedule.scheduled_resource_oid fkcresource_schedule_scheduled_resource_oid
ticket.location_oid fkticket_location
ticket.resource_oid fkticket_res
creation_date timestamptz 35,6  √  null
creating_operator_oid int8 19  √  null
modified timestamptz 35,6  √  null
deleted bool 1 false
origin varchar 2147483647
unique_identifier 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
checkout_center_oid int8 19
checkout_center.obj_oid resource_checkout_center_oid_fkey
assigned_person_oid int8 19  √  null
person.obj_oid fkcres_person
assigned_department_oid int8 19  √  null
department.obj_oid fkcres_department
shelf_location varchar 2147483647  √  null
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
first_schedule_oid int8 19  √  null
previous_schedule_oid int8 19  √  null
current_schedule_oid int8 19  √  null
next_schedule_oid int8 19  √  null

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

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
checkout_center_oid Performance Asc resource_checkout_center_oid_idx  
label_id Must be unique Asc resource_label_id_key  
location_resource_oid Performance Asc resource_location_resource_oid_idx  
metaclass Performance Asc resource_metaclass_idx  
checkout_center_oid + rtype_oid Performance Asc/Asc resource_type_location_idx  
unique_identifier Must be unique Asc resource_unique_identifier_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: