Table webco_4.7.public.inventory_item 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
inventory_oid int8 19
inventory.obj_oid inventory_item_inventory_oid_fkey
resource_oid int8 19
resource.obj_oid inventory_item_resource_oid_fkey
scan_value varchar 2147483647  √  null
scan_type varchar 2147483647  √  null
date timestamptz 35,6  √  null
scanning_agent_oid int8 19  √  null
person.obj_oid inventory_item_scanning_agent_oid_fkey
inventoried_home_location_oid int8 19  √  null
resource.obj_oid inventory_item_inventoried_home_location_oid_fkey
inventoried_assigned_person_oid int8 19  √  null
person.obj_oid inventory_item_inventoried_assigned_person_oid_fkey
inventoried_assigned_department_oid int8 19  √  null
department.obj_oid inventory_item_inventoried_assigned_department_oid_fkey

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

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc inventory_item_pkey
inventory_oid Performance Asc inventory_item_inventory_oid_idx
resource_oid Performance Asc inventory_item_resource_oid_idx

Close relationships  within of separation: