wms_inv_load_unit

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_height int4 10 √ null
c_length int4 10 √ null
c_locked bool 1 √ null
c_mixed_products bool 1 √ null
c_width int4 10 √ null
c_created timestamp 29,6 √ null
c_ol int8 19 √ null
c_pk int8 19 null
wms_inv_packaging_unit.c_load_unit fk_lu_pk R
c_product_pk int8 19 √ null
wms_inv_product.c_pk fk_lu_product_pk R
c_transport_unit_pk int8 19 null
wms_inv_transport_unit.c_pk fk_lu_tu_pk R
c_updated timestamp 29,6 √ null
c_created_by varchar 255 √ null
c_label varchar 255 √ null
c_load_unit_type varchar 255 null
wms_inv_load_unit_type.c_type fk_lut_type R
c_physical_pos varchar 255 null
c_pid varchar 255 null
c_uom varchar 255 √ null
c_updated_by varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
wms_inv_load_unit_pkey Primary key Asc c_pk
uc_lu_label Must be unique Asc c_label
uc_lu_tupk_pos Must be unique Asc/Asc c_transport_unit_pk + c_physical_pos
wms_inv_load_unit_c_pid_key Must be unique Asc c_pid

Relationships

Close relationships within degrees of separation