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

Constraint Name Child Column Parent Column Delete Rule
m_product_m_product_acct m_product_acct.m_product_id m_product.m_product_id Cascade on delete 
masi_mbomproduct m_bomproduct.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattrsetinst_mproduct m_product.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mbom_mbomproduct m_bomproduct.m_bom_id m_bom.m_bom_id Cascade on delete 
mbom_rgroup r_group.m_bom_id m_bom.m_bom_id Restrict delete 
mbomalternative_mbomproduct m_bomproduct.m_bomalternative_id m_bomalternative.m_bomalternative_id Restrict delete 
mchangenotice_rgroup r_group.m_changenotice_id m_changenotice.m_changenotice_id Restrict delete 
mchangerequest_rrequest r_request.m_changerequest_id m_changerequest.m_changerequest_id Restrict delete 
mcn_mbom m_bom.m_changenotice_id m_changenotice.m_changenotice_id Restrict delete 
mcn_mbomproduct m_bomproduct.m_changenotice_id m_changenotice.m_changenotice_id Null on delete 
mcn_mcr m_changerequest.m_changenotice_id m_changenotice.m_changenotice_id Restrict delete 
mfixchangenotice_mchangereques m_changerequest.m_fixchangenotice_id m_changenotice.m_changenotice_id Restrict delete 
mfixchangenotice_rrequest r_request.m_fixchangenotice_id m_changenotice.m_changenotice_id Restrict delete 
mproduct_mbom m_bom.m_product_id m_product.m_product_id Cascade on delete 
mproduct_mbomalternative m_bomalternative.m_product_id m_product.m_product_id Cascade on delete 
mproduct_mbomproduct m_bomproduct.m_productbom_id m_product.m_product_id Restrict delete 
mproduct_mproductoperation m_productoperation.m_product_id m_product.m_product_id Cascade on delete 
mproduct_rcategory r_category.m_product_id m_product.m_product_id Restrict delete 
mproduct_rrequest r_request.m_product_id m_product.m_product_id Restrict delete 
mproductop_mbomproduct m_bomproduct.m_productoperation_id m_productoperation.m_productoperation_id Restrict delete 
mproductop_mopresource m_operationresource.m_productoperation_id m_productoperation.m_productoperation_id Cascade on delete 
mproductspent_rrequest r_request.m_productspent_id m_product.m_product_id Restrict delete 
rcategory_rrequest r_request.r_category_id r_category.r_category_id Restrict delete 
rgroup_rrequest r_request.r_group_id r_group.r_group_id Restrict delete 
rrequest_related r_request.r_requestrelated_id r_request.r_request_id Restrict delete 
rrequesttype_rrequest r_request.r_requesttype_id r_requesttype.r_requesttype_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected