Table testdb.public.wms_inv_packaging_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_parent fk_pu_pu_parent R
wms_inv_reservation.c_packaging_unit_pk fk_pureservation_pk R
c_created timestamp 29,6  √  null
c_updated timestamp 29,6  √  null
c_ol int8 19  √  null
c_pid varchar 255
c_av_state varchar 255
c_height int4 10  √  null
c_length int4 10  √  null
c_uom varchar 255  √  null
c_width int4 10  √  null
c_fifo_date timestamp 29,6  √  null
c_labels varchar 1024  √  null
c_lot_pkey varchar 255  √  null
c_message_no int4 10  √  null
c_message_text varchar 255  √  null
physical_position varchar 255  √  null
c_qty_type varchar 255
c_qty varchar 16
c_serial_number varchar 255  √  null
c_weight_type varchar 255  √  null
c_weight varchar 255  √  null
c_actual_location int8 19  √  null
wms_inv_location.c_pk fk_pu_loc_pk R
c_load_unit int8 19  √  null
wms_inv_load_unit.c_pk fk_lu_pk R
c_parent int8 19  √  null
wms_inv_packaging_unit.c_pk fk_pu_pu_parent R
c_product_pk int8 19  √  null
wms_inv_product.c_pk fk_pu_product_pk R

Table contained 0 rows at Mon Oct 18 20:49 UTC 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
c_pk Primary key Asc wms_inv_packaging_unit_pkey  
c_serial_number Must be unique Asc uc_pu_sn This unique column is also nullable

Close relationships  within of separation: