Table testdb.public.wms_inv_transport_unit Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
c_pk int8 19
wms_inv_load_unit
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_acknowledged bool 1  √  null
c_actual_location_date timestamp 29,6  √  null
c_customer_order_id varchar 255  √  null
c_foreign_pid varchar 255  √  null
c_height int4 10  √  null
c_length int4 10  √  null
c_reconciled_at timestamp 22  √  null
c_reconciled_by varchar 255  √  null
c_state varchar 255  √  null
c_target varchar 255  √  null
c_transport_unit_bk varchar 255
c_transport_unit_type varchar 255
c_width int4 10  √  null
c_actual_location int8 19
wms_inv_location

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

Indexes:
Column(s) Type Sort Anomalies
c_pk Primary key Asc  
c_transport_unit_bk Must be unique Asc  
c_foreign_pid Must be unique Asc This unique column is also nullable
c_pid Must be unique Asc  

Close relationships  within of separation: