Table testdb.public.wms_inv_product_stacking_rule 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
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_no_products int4 10
c_allowed_product int8 19
wms_inv_product.c_pk fk_psr_ap_product R
c_base_product int8 19
wms_inv_product.c_pk fk_psr_bp_product 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_stacking_rule_pkey
c_base_product + c_allowed_product Must be unique Asc/Asc uc_prodstrule
c_pid Must be unique Asc uk_5gik6drl0vgrytgnhtodl75fd

Close relationships  within of separation: