Table testdb.public.wms_inv_product 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_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_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_account varchar 255  √  null
c_av_state varchar 255  √  null
c_base_unit_type varchar 255
c_base_unit_qty varchar 16
c_classification varchar 255  √  null
c_description varchar 255  √  null
c_description_text oid 10  √  null
c_height int4 10  √  null
c_length int4 10  √  null
c_uom varchar 255  √  null
c_width int4 10  √  null
c_group varchar 255  √  null
c_label varchar 255  √  null
c_weight_type varchar 255  √  null
c_weight varchar 16  √  null
c_overbooking_allowed bool 1
c_sku varchar 255
c_stock_zone varchar 255  √  null
c_preferable_storage_location int8 19  √  null
wms_inv_location.c_pk fk_prod_loc_pk R

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

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

Close relationships  within of separation: