inventory

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
inventory_item.inventory_oid inventory_item_inventory_oid_fkeyC
inventory_note.inventory_oid inventory_note_inventory_oid_fkeyC
inventory_selector.inventory_oid inventory_selector_inventory_oid_fkeyC
name varchar 2147483647 √ null
description varchar 2147483647 √ null
organization_oid int8 19 √ null
organization.obj_oid inventory_organization_oid_fkeyC
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 null
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

Indexes

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

Check Constraints

Constraint Name Constraint
inventory_allow_manual_check (((allow_manual)::text = ANY ((ARRAY['NO-BARCODE'::character varying, 'ALWAYS'::character varying, 'NEVER'::character varying])::text[])))

Relationships

Close relationships within degrees of separation