Table testdb.public.wms_inv_location Generated by
SchemaSpy
Legend:
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
c_pk int8 19
wms_inv_packaging_unit.c_actual_location fk_pu_loc_pk R
wms_inv_product.c_preferable_storage_location fk_prod_loc_pk R
wms_inv_transport_unit.c_actual_location fk_loc_pk R
c_created timestamp 29,6  √  null
c_created_by varchar 255  √  null
c_updated_by varchar 255  √  null
c_updated timestamp 29,6  √  null
c_ol int8 19  √  null
c_pid varchar 255
c_classification varchar 255  √  null
c_description varchar 255  √  null
c_direct_booking_allowed bool 1  √  null
c_erp_code varchar 255  √  null
c_foreign_pid varchar 255  √  null
c_incoming_active bool 1  √  null
c_last_inventory_date timestamp 22  √  null
c_last_pick_date timestamp 22  √  null
c_location_group varchar 255  √  null
c_aisle varchar 4
c_area varchar 4
c_x varchar 4
c_y varchar 4
c_z varchar 4
c_mixed_products bool 1  √  null
c_no_max_transport_units int4 10  √  null
c_outgoing_active bool 1  √  null
c_plc_state int4 10  √  null
c_sort int4 10  √  null
c_stock_zone varchar 255  √  null

Table contained 0 rows at Mon Aug 21 16:18 UTC 2023

Indexes:
Column(s) Type Sort Constraint Name Anomalies
c_pk Primary key Asc wms_inv_location_pkey  
c_area + c_aisle + c_x + c_y + c_z Must be unique Asc/Asc/Asc/Asc/Asc uc_coordinate  
c_foreign_pid Must be unique Asc uc_loc_foreign_pid This unique column is also nullable
c_pid Must be unique Asc uk_5v9h0pr1215p1m2hl0chrniuy  

Close relationships  within of separation: