wms_inv_product

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_height int4 10 √ null
c_length int4 10 √ null
c_overbooking_allowed 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_load_unit.c_product_pk fk_lu_product_pk R
wms_inv_packaging_unit.c_product_pk fk_pu_product_pk R
wms_inv_product_detail.c_product_pk fk_details_product R
wms_inv_product_stacking_rule.c_allowed_product fk_psr_ap_product R
wms_inv_product_stacking_rule.c_base_product fk_psr_bp_product R
wms_inv_product_unit.c_product_pk fk_punit_product R
c_preferable_storage_location int8 19 √ null
wms_inv_location.c_pk fk_prod_loc_pk R
c_updated timestamp 29,6 √ null
c_weight varchar 16 √ null
c_account varchar 255 √ null
c_av_state varchar 255 √ null
c_base_unit_qty varchar 255 null
c_base_unit_type varchar 255 null
c_classification varchar 255 √ null
c_created_by varchar 255 √ null
c_description varchar 255 √ null
c_group varchar 255 √ null
c_label varchar 255 √ null
c_pid varchar 255 null
c_sku varchar 255 null
c_stock_zone varchar 255 √ null
c_uom varchar 255 √ null
c_updated_by varchar 255 √ null
c_weight_type varchar 255 √ null
c_description_text oid 10 √ null

Indexes

Constraint Name Type Sort Column(s)
wms_inv_product_pkey Primary key Asc c_pk
uc_inv_product_sku Must be unique Asc c_sku
wms_inv_product_c_pid_key Must be unique Asc c_pid

Check Constraints

Constraint Name Constraint
wms_inv_product_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