SchemaSpy Analysis of idempiere9.adempiere - ConstraintsPerformance Analysis Generated by
Quality Systems & Solutions
88 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
ad_org_c_acctschema c_acctschema.ad_org_id ad_org.ad_org_id Restrict delete 
ad_org_mproduct m_product.ad_org_id ad_org.ad_org_id Restrict delete 
ad_roleorg ad_role.ad_org_id ad_org.ad_org_id Restrict delete 
ad_user_org ad_user.ad_org_id ad_org.ad_org_id Restrict delete 
adalert_adalertrecipient ad_alertrecipient.ad_alert_id ad_alert.ad_alert_id Restrict delete 
adaltert_aralertrule ad_alertrule.ad_alert_id ad_alert.ad_alert_id Restrict delete 
adchart_adchartdatasource ad_chartdatasource.ad_chart_id ad_chart.ad_chart_id Restrict delete 
adchart_padashboardcontent pa_dashboardcontent.ad_chart_id ad_chart.ad_chart_id Restrict delete 
adorg2_pagoalrestriction pa_goalrestriction.org_id ad_org.ad_org_id Restrict delete 
adorg_cbpartner c_bpartner.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_cbpartnerorg c_bpartner.ad_orgbp_id ad_org.ad_org_id Restrict delete 
adorg_celementvalue c_elementvalue.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_padashboardcontentaccess pa_dashboardcontent_access.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_pagoalrestriction pa_goalrestriction.ad_org_id ad_org.ad_org_id Restrict delete 
adorgonly_cacctschema c_acctschema.ad_orgonly_id ad_org.ad_org_id Restrict delete 
adorgtrx_aduser ad_user.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adprintcolor1_pacolorschema pa_colorschema.ad_printcolor1_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor2_pacolorschema pa_colorschema.ad_printcolor2_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor3_pacolorschema pa_colorschema.ad_printcolor3_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor4_pacolorschema pa_colorschema.ad_printcolor4_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor_cbpgroup c_bp_group.ad_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor_mproductcategory m_product_category.ad_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
adrole_adaltertrecipient ad_alertrecipient.ad_role_id ad_role.ad_role_id Restrict delete 
adrole_padashboardcontent pa_dashboardcontent.ad_role_id ad_role.ad_role_id Restrict delete 
adrole_padashboardcontentacces pa_dashboardcontent_access.ad_role_id ad_role.ad_role_id Restrict delete 
adrole_padashboardpreference pa_dashboardpreference.ad_role_id ad_role.ad_role_id Restrict delete 
adrole_padocumentstatus pa_documentstatus.ad_role_id ad_role.ad_role_id Cascade on delete 
adrole_padocumentstatusaccess pa_documentstatusaccess.ad_role_id ad_role.ad_role_id Cascade on delete 
adrole_pagoal pa_goal.ad_role_id ad_role.ad_role_id Restrict delete 
adtable_adaltertrule ad_alertrule.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adchartdatasource ad_chartdatasource.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_padocumentstatus pa_documentstatus.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_pameasurecalc pa_measurecalc.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_paslameasure pa_sla_measure.ad_table_id ad_table.ad_table_id Restrict delete 
aduser_adalertrecipient ad_alertrecipient.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_padashboardcontent pa_dashboardcontent.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_padashboardcontentacces pa_dashboardcontent_access.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_padashboardpreference pa_dashboardpreference.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_padocumentstatus pa_documentstatus.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_padocumentstatusaccess pa_documentstatusaccess.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_pagoal pa_goal.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_supervisor ad_user.supervisor_id ad_user.ad_user_id Restrict delete 
adusersalesrep_cbpartner c_bpartner.salesrep_id ad_user.ad_user_id Null on delete 
adusersupervisor_adrole ad_role.supervisor_id ad_user.ad_user_id Restrict delete 
cacctschema_paratio pa_ratio.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cbpartner_aduser ad_user.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_pagoalrestriction pa_goalrestriction.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_paslagoal pa_sla_goal.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpgroup_cbpartner c_bpartner.c_bp_group_id c_bp_group.c_bp_group_id Restrict delete 
cbpgroup_pagoalrestriction pa_goalrestriction.c_bp_group_id c_bp_group.c_bp_group_id Restrict delete 
celementvalue_paratioelement pa_ratioelement.account_id c_elementvalue.c_elementvalue_id Restrict delete 
cprojecttype_cphase c_phase.c_projecttype_id c_projecttype.c_projecttype_id Cascade on delete 
cprojecttype_pameasure pa_measure.c_projecttype_id c_projecttype.c_projecttype_id Restrict delete 
createdby_padashboardcontentac pa_dashboardcontent_access.createdby ad_user.ad_user_id Restrict delete 
mproduct_cphase c_phase.m_product_id m_product.m_product_id Restrict delete 
mproduct_mproductcategory m_product.m_product_category_id m_product_category.m_product_category_id Restrict delete 
mproduct_pagoalrestriction pa_goalrestriction.m_product_id m_product.m_product_id Restrict delete 
mproductcat_pagoalrestriction pa_goalrestriction.m_product_category_id m_product_category.m_product_category_id Restrict delete 
mproductcat_parentcat m_product_category.m_product_category_parent_id m_product_category.m_product_category_id Restrict delete 
nameprintcolor_padocumentstatu pa_documentstatus.name_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
nextstatus_rstatus r_status.next_status_id r_status.r_status_id Restrict delete 
numberprintcolor_padocumentsta pa_documentstatus.number_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
pabenchmark_pabenchmarkdata pa_benchmarkdata.pa_benchmark_id pa_benchmark.pa_benchmark_id Cascade on delete 
pabenchmark_pameasure pa_measure.pa_benchmark_id pa_benchmark.pa_benchmark_id Restrict delete 
pacolorschema_pagoal pa_goal.pa_colorschema_id pa_colorschema.pa_colorschema_id Restrict delete 
padashboardcontacc_padashboard pa_dashboardcontent_access.pa_dashboardcontent_id pa_dashboardcontent.pa_dashboardcontent_id Restrict delete 
padashboardcontent_padashpref pa_dashboardpreference.pa_dashboardcontent_id pa_dashboardcontent.pa_dashboardcontent_id Restrict delete 
padocumentstatus_padocstataccs pa_documentstatusaccess.pa_documentstatus_id pa_documentstatus.pa_documentstatus_id Restrict delete 
pagoal_padashboardcontent pa_dashboardcontent.pa_goal_id pa_goal.pa_goal_id Restrict delete 
pagoal_pagoalrestriction pa_goalrestriction.pa_goal_id pa_goal.pa_goal_id Restrict delete 
pagoalparent_pagoal pa_goal.pa_goalparent_id pa_goal.pa_goal_id Restrict delete 
pahierarchy_pameasure pa_measure.pa_hierarchy_id pa_hierarchy.pa_hierarchy_id Restrict delete 
pameasure_paachievement pa_achievement.pa_measure_id pa_measure.pa_measure_id Restrict delete 
pameasure_pagoal pa_goal.pa_measure_id pa_measure.pa_measure_id Restrict delete 
pameasurecalc_pameasure pa_measure.pa_measurecalc_id pa_measurecalc.pa_measurecalc_id Restrict delete 
pameasurecalc_paratioelement pa_ratioelement.pa_measurecalc_id pa_measurecalc.pa_measurecalc_id Restrict delete 
paratio_pameasure pa_measure.pa_ratio_id pa_ratio.pa_ratio_id Restrict delete 
paratio_paratioelement pa_ratioelement.pa_ratio_id pa_ratio.pa_ratio_id Restrict delete 
paratioused_paratioelement pa_ratioelement.pa_ratioused_id pa_ratio.pa_ratio_id Restrict delete 
paslacriteria_paslagoal pa_sla_goal.pa_sla_criteria_id pa_sla_criteria.pa_sla_criteria_id Restrict delete 
paslagoal_paslameasure pa_sla_measure.pa_sla_goal_id pa_sla_goal.pa_sla_goal_id Restrict delete 
rrequesttype_pameasure pa_measure.r_requesttype_id r_requesttype.r_requesttype_id Restrict delete 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 
salesrep_mproduct m_product.salesrep_id ad_user.ad_user_id Restrict delete 
tableorg ad_table.ad_org_id ad_org.ad_org_id Restrict delete 
updatedby_padashboardcontentac pa_dashboardcontent_access.updatedby ad_user.ad_user_id Restrict delete 
updatestatus_rstatus r_status.update_status_id r_status.r_status_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected