SchemaSpy Analysis of idempiere9.adempiere - ConstraintsProduct Price Generated by
Quality Systems & Solutions
39 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
basepricelist m_pricelist.basepricelist_id m_pricelist.m_pricelist_id Restrict delete 
c_buspartner_m_product_po m_product_po.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cbpproduct c_bpartner_product.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_mdiscountsline m_discountschemaline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_mproductpricevendorb m_productpricevendorbreak.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_mpromotionpreconditi m_promotionprecondition.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
m_product_productpo m_product_po.m_product_id m_product.m_product_id Cascade on delete 
mdiscounts_cbpartner c_bpartner.m_discountschema_id m_discountschema.m_discountschema_id Restrict delete 
mdiscounts_mdsbreak m_discountschemabreak.m_discountschema_id m_discountschema.m_discountschema_id Cascade on delete 
mdiscounts_mplversion m_pricelist_version.m_discountschema_id m_discountschema.m_discountschema_id Restrict delete 
mdiscountschema_mdsline m_discountschemaline.m_discountschema_id m_discountschema.m_discountschema_id Cascade on delete 
mdiscountspo_cbpartner c_bpartner.po_discountschema_id m_discountschema.m_discountschema_id Restrict delete 
mpricelist_cbpartner c_bpartner.m_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mpricelist_mpricelistversion m_pricelist_version.m_pricelist_id m_pricelist.m_pricelist_id Cascade on delete 
mpricelist_mpromotionprecondit m_promotionprecondition.m_pricelist_id m_pricelist.m_pricelist_id Restrict delete 
mpricelistpo_cbuspartner c_bpartner.po_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mpricelistver_mproductprice m_productprice.m_pricelist_version_id m_pricelist_version.m_pricelist_version_id Cascade on delete 
mpricelistversion_mproductpric m_productpricevendorbreak.m_pricelist_version_id m_pricelist_version.m_pricelist_version_id Restrict delete 
mpricelistversionbase_mpriceli m_pricelist_version.m_pricelist_version_base_id m_pricelist_version.m_pricelist_version_id Restrict delete 
mprodcategory_mdiscountsbreak m_discountschemabreak.m_product_category_id m_product_category.m_product_category_id Restrict delete 
mprodcategory_mdiscountsline m_discountschemaline.m_product_category_id m_product_category.m_product_category_id Restrict delete 
mproduct_cbpproduct c_bpartner_product.m_product_id m_product.m_product_id Cascade on delete 
mproduct_mdiscountsbreak m_discountschemabreak.m_product_id m_product.m_product_id Restrict delete 
mproduct_mdiscountsline m_discountschemaline.m_product_id m_product.m_product_id Null on delete 
mproduct_mproductcategory m_product.m_product_category_id m_product_category.m_product_category_id Restrict delete 
mproduct_mproductprice m_productprice.m_product_id m_product.m_product_id Cascade on delete 
mproduct_mproductpricevendorbr m_productpricevendorbreak.m_product_id m_product.m_product_id Restrict delete 
mproduct_mpromotiongroupline m_promotiongroupline.m_product_id m_product.m_product_id Restrict delete 
mproductcat_parentcat m_product_category.m_product_category_parent_id m_product_category.m_product_category_id Restrict delete 
mpromotion_mpromotiondistribut m_promotiondistribution.m_promotion_id m_promotion.m_promotion_id Restrict delete 
mpromotion_mpromotionline m_promotionline.m_promotion_id m_promotion.m_promotion_id Restrict delete 
mpromotion_mpromotionprecondit m_promotionprecondition.m_promotion_id m_promotion.m_promotion_id Restrict delete 
mpromotion_mpromotionreward m_promotionreward.m_promotion_id m_promotion.m_promotion_id Restrict delete 
mpromotiondistribution_mpromot m_promotionreward.m_promotiondistribution_id m_promotiondistribution.m_promotiondistribution_id Restrict delete 
mpromotiongroup_mpromotiongrou m_promotiongroupline.m_promotiongroup_id m_promotiongroup.m_promotiongroup_id Restrict delete 
mpromotiongroup_mpromotionline m_promotionline.m_promotiongroup_id m_promotiongroup.m_promotiongroup_id Restrict delete 
mpromotionline_mpromotiondistr m_promotiondistribution.m_promotionline_id m_promotionline.m_promotionline_id Restrict delete 
mtargetdistribution_mpromotion m_promotionreward.m_targetdistribution_id m_promotiondistribution.m_promotiondistribution_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected