Table webco_5.0.public.inventory 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_item.inventory_oid inventory_item_inventory_oid_fkey
inventory_note.inventory_oid inventory_note_inventory_oid_fkey
inventory_selector.inventory_oid inventory_selector_inventory_oid_fkey
name varchar 2147483647  √  null
description varchar 2147483647  √  null
organization_oid int8 19  √  null
organization.obj_oid inventory_organization_oid_fkey
start_date timestamptz 35,6  √  null
end_date timestamptz 35,6  √  null
open_date timestamptz 35,6  √  null
close_date timestamptz 35,6  √  null
auto_open bool 1  √  false
auto_close bool 1  √  false
inventory_on_checkout bool 1  √  false
inventory_on_return bool 1  √  false
update_resources bool 1  √  false
allow_manual varchar 2147483647
require_location bool 1  √  false
allow_update_location bool 1  √  false
allow_add_unexpected bool 1  √  false
include_maint_notes bool 1  √  false
include_instructions bool 1  √  false
instructions varchar 2147483647  √  null

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

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

Close relationships  within of separation: