wms_inv_packaging_unit_log

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_alive bool 1 √ null
c_height int4 10 √ null
c_length int4 10 √ null
c_message_no int4 10 √ null
c_rev_type int2 5 √ null
c_width int4 10 √ null
c_actual_location int8 19 √ null
c_created timestamp 29,6 √ null
c_expires_at timestamp 22 √ null
c_fifo_date timestamp 29,6 √ null
c_load_unit int8 19 √ null
c_parent int8 19 √ null
c_pk int8 19 null
c_produced_at timestamp 22 √ null
c_product_pk int8 19 √ null
c_rev int8 19 null
wms_inv_revision.c_pk fkorslxj6jole226itq5c7cy8ax C
c_uom_relation int8 19 √ null
c_updated timestamp 29,6 √ null
c_qty varchar 16 √ null
c_labels varchar 1024 √ null
c_av_state varchar 255 √ null
c_created_by varchar 255 √ null
c_lot_id varchar 255 √ null
c_message_text varchar 255 √ null
c_physical_pos varchar 255 √ null
c_pid varchar 255 √ null
c_qty_type varchar 255 √ null
c_serial_number varchar 255 √ null
c_uom varchar 255 √ null
c_updated_by varchar 255 √ null
c_weight varchar 255 √ null
c_weight_type varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
wms_inv_packaging_unit_log_pkey Primary key Asc/Asc c_pk + c_rev

Check Constraints

Constraint Name Constraint
wms_inv_packaging_unit_log_c_av_state_check ((c_av_state)::text = ANY ((ARRAY['LOCKED'::character varying, 'QC_LOCKED'::character varying, 'AVAILABLE'::character varying])::text[]))

Relationships

Close relationships within degrees of separation