SchemaSpy Analysis of idempiere9.adempiere - ConstraintsAccounting Defaults Generated by
Quality Systems & Solutions
25 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
c_buspartner_c_bp_vendor_acct c_bp_vendor_acct.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cacctschema1_adclientinfo ad_clientinfo.c_acctschema1_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_aassetacct a_asset_acct.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_aassetgroupacct a_asset_group_acct.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_cacctschemagl c_acctschema_gl.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_cbankaccountacct c_bankaccount_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_cbpcustomeracct c_bp_customer_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_cbpemployeeacct c_bp_employee_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_cbpgroupacct c_bp_group_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_cbpvendoracct c_bp_vendor_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_cchargeacct c_charge_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_cinterorgacct c_interorg_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_cprojectacct c_project_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_ctaxacct c_tax_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_cwithholdingacct c_withholding_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_default c_acctschema_default.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_mprodcatacct m_product_category_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_mproductacct m_product_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_mwarehouseacct m_warehouse_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cbpartner_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnercashtrx_adclientinfo ad_clientinfo.c_bpartnercashtrx_id c_bpartner.c_bpartner_id Restrict delete 
cbuspartner_c_bpemployeeacct c_bp_employee_acct.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbuspartner_cbpcustomer_acct c_bp_customer_acct.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
m_product_m_product_acct m_product_acct.m_product_id m_product.m_product_id Cascade on delete 
mproductfreight_adclientinfo ad_clientinfo.m_productfreight_id m_product.m_product_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected