inventory_item

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
inventory_oid int8 19 null
inventory.obj_oid inventory_item_inventory_oid_fkeyC
resource_oid int8 19 null
resource.obj_oid inventory_item_resource_oid_fkeyC
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_fkeyN
inventoried_home_location_oid int8 19 √ null
resource.obj_oid inventory_item_inventoried_home_location_oid_fkeyN
inventoried_assigned_person_oid int8 19 √ null
person.obj_oid inventory_item_inventoried_assigned_person_oid_fkeyN
inventoried_assigned_department_oid int8 19 √ null
department.obj_oid inventory_item_inventoried_assigned_department_oid_fkeyN

Indexes

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

Check Constraints

Constraint Name Constraint
inventory_item_scan_type_check (((scan_type)::text = ANY ((ARRAY['PICKUP'::character varying, 'RETURN'::character varying, 'BARCODE'::character varying, 'ID'::character varying, 'MANUAL'::character varying])::text[])))

Relationships

Close relationships within degrees of separation