SchemaSpy Analysis of idempiere11.adempiere - ConstraintsAccounting Generated by
Quality Systems & Solutions
51 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
aasset_factacct fact_acct.a_asset_id a_asset.a_asset_id Restrict delete 
account_factacctsummary fact_acct_summary.account_id c_elementvalue.c_elementvalue_id Restrict delete 
ad_org_c_acctschema c_acctschema.ad_org_id ad_org.ad_org_id Restrict delete 
ad_org_fact_acct fact_acct.ad_org_id ad_org.ad_org_id Restrict delete 
ad_orgtrx_fact_acct fact_acct.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorg_caschemaelement c_acctschema_element.org_id ad_org.ad_org_id Restrict delete 
adorg_celementvalue c_elementvalue.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_vc c_validcombination.ad_org_id ad_org.ad_org_id Restrict delete 
adorgid_c_aschemaelement c_acctschema_element.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_factacctsummary fact_acct_summary.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_vc c_validcombination.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adtable_factacct fact_acct.ad_table_id ad_table.ad_table_id Restrict delete 
aparentasset_aasset a_asset.a_parent_asset_id a_asset.a_asset_id Restrict delete 
c_calendar_year c_year.c_calendar_id c_calendar.c_calendar_id Restrict delete 
c_calendarorg c_calendar.ad_org_id ad_org.ad_org_id Restrict delete 
c_elementorg c_element.ad_org_id ad_org.ad_org_id Restrict delete 
c_periodorg c_period.ad_org_id ad_org.ad_org_id Restrict delete 
c_year_period c_period.c_year_id c_year.c_year_id Restrict delete 
c_yearorg c_year.ad_org_id ad_org.ad_org_id Restrict delete 
cacctschema1_adclientinfo ad_clientinfo.c_acctschema1_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_caschemaelement c_acctschema_element.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_cvalidcombination c_validcombination.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_factacct fact_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_factacctsummary fact_acct_summary.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
ccalendar_adclientinfo ad_clientinfo.c_calendar_id c_calendar.c_calendar_id Restrict delete 
celement_caschemaelement c_acctschema_element.c_element_id c_element.c_element_id Restrict delete 
celement_celementvalue c_elementvalue.c_element_id c_element.c_element_id Cascade on delete 
celementvalue_caschemaelement c_acctschema_element.c_elementvalue_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalue_csubacct c_subacct.c_elementvalue_id c_elementvalue.c_elementvalue_id Cascade on delete 
celementvalue_factacct fact_acct.account_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueaccount_vc c_validcombination.account_id c_elementvalue.c_elementvalue_id Cascade on delete 
celementvalueuser1_factacct fact_acct.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser1_vc c_validcombination.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser2_factacct fact_acct.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser2_vc c_validcombination.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
cperiod_cacctschema c_acctschema.c_period_id c_period.c_period_id Restrict delete 
cperiod_factacct fact_acct.c_period_id c_period.c_period_id Restrict delete 
cperiod_factacctsummary fact_acct_summary.c_period_id c_period.c_period_id Restrict delete 
csubacct_cvalidcombination c_validcombination.c_subacct_id c_subacct.c_subacct_id Restrict delete 
csubacct_factacct fact_acct.c_subacct_id c_subacct.c_subacct_id Restrict delete 
csubacct_factacctsummary fact_acct_summary.c_subacct_id c_subacct.c_subacct_id Restrict delete 
ctax_factacct fact_acct.c_tax_id c_tax.c_tax_id Restrict delete 
ctax_parent c_tax.parent_tax_id c_tax.c_tax_id Restrict delete 
factacct_factreconciliation fact_reconciliation.fact_acct_id fact_acct.fact_acct_id Restrict delete 
glbudget_factacct fact_acct.gl_budget_id gl_budget.gl_budget_id Restrict delete 
glbudget_factacctsummary fact_acct_summary.gl_budget_id gl_budget.gl_budget_id Restrict delete 
glcategory_factacct fact_acct.gl_category_id gl_category.gl_category_id Restrict delete 
tableorg ad_table.ad_org_id ad_org.ad_org_id Restrict delete 
user1_factacctsummary fact_acct_summary.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
user2_factacctsummary fact_acct_summary.user2_id c_elementvalue.c_elementvalue_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected