Table testdb.public.wms_inv_load_unit 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_load_unit fk_lu_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_height int4 10  √  null
c_length int4 10  √  null
c_uom varchar 255  √  null
c_width int4 10  √  null
c_label varchar 255  √  null
c_locked bool 1  √  null
c_mixed_products bool 1  √  null
c_physical_pos varchar 255
c_product_pk int8 19  √  null
wms_inv_product.c_pk fk_lu_product_pk R
c_transport_unit_pk int8 19
wms_inv_transport_unit.c_pk fk_lu_tu_pk R
c_load_unit_type varchar 255
wms_inv_load_unit_type.c_type fk_lut_type R

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_load_unit_pkey  
c_label Must be unique Asc uc_lu_label This unique column is also nullable
c_transport_unit_pk + c_physical_pos Must be unique Asc/Asc uc_lu_tupk_pos  
c_pid Must be unique Asc uk_2m5araje49tnd0df1k3h2ieun  

Close relationships  within of separation: