SchemaSpy Analysis of idempiere9.adempiere - ConstraintsCommon Application Generated by
Quality Systems & Solutions
80 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
benefici_cwithholding c_withholding.beneficiary c_bpartner.c_bpartner_id Restrict delete 
c_calendar_year c_year.c_calendar_id c_calendar.c_calendar_id Restrict delete 
c_calendarnonbusinessday c_nonbusinessday.c_calendar_id c_calendar.c_calendar_id Restrict delete 
c_country_c_tax c_tax.c_country_id c_country.c_country_id Restrict delete 
c_country_location c_location.c_country_id c_country.c_country_id Restrict delete 
c_countryto_c_tax c_tax.to_country_id c_country.c_country_id Restrict delete 
c_currency_c_acctschema c_acctschema.c_currency_id c_currency.c_currency_id Restrict delete 
c_currencyconvrateto c_conversion_rate.c_currency_id_to c_currency.c_currency_id Restrict delete 
c_location_warehouse m_warehouse.c_location_id c_location.c_location_id Restrict delete 
c_period_periodcontrol c_periodcontrol.c_period_id c_period.c_period_id Restrict delete 
c_region_c_tax c_tax.c_region_id c_region.c_region_id Restrict delete 
c_region_location c_location.c_region_id c_region.c_region_id Restrict delete 
c_regionto_c_tax c_tax.to_region_id c_region.c_region_id Restrict delete 
c_uomconversionto c_uom_conversion.c_uom_to_id c_uom.c_uom_id Restrict delete 
c_year_period c_period.c_year_id c_year.c_year_id Restrict delete 
cacctschema_cvalidcombination c_validcombination.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cactivity_cproject c_project.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_cvalidcombination c_validcombination.c_activity_id c_activity.c_activity_id Restrict delete 
cbank_cbankaccount c_bankaccount.c_bank_id c_bank.c_bank_id Cascade on delete 
cbank_cbpbankaccount c_bp_bankaccount.c_bank_id c_bank.c_bank_id Null on delete 
cbankaccount_celementvalue c_elementvalue.c_bankaccount_id c_bankaccount.c_bankaccount_id Restrict delete 
cbpartner_cbpbankaccount c_bp_bankaccount.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_cbplocation c_bpartner_location.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_cbpwithholding c_bp_withholding.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_cproject c_project.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_vc c_validcombination.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnersr_cproject c_project.c_bpartnersr_id c_bpartner.c_bpartner_id Restrict delete 
cbplocation_cproject c_project.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
ccampaign_cproject c_project.c_campaign_id c_campaign.c_campaign_id Restrict delete 
cchannel_ccampaign c_campaign.c_channel_id c_channel.c_channel_id Restrict delete 
ccity_clocation c_location.c_city_id c_city.c_city_id Restrict delete 
ccountry_ccity c_city.c_country_id c_country.c_country_id Restrict delete 
ccountry_ccountry c_country.c_country_id c_country.c_country_id Restrict delete 
ccountry_ccountrygroupcountry c_countrygroupcountry.c_country_id c_country.c_country_id Restrict delete 
ccountry_cnonbusinessday c_nonbusinessday.c_country_id c_country.c_country_id Restrict delete 
ccountry_cregion c_region.c_country_id c_country.c_country_id Restrict delete 
ccountrygroup_ccountrygroupcou c_countrygroupcountry.c_countrygroup_id c_countrygroup.c_countrygroup_id Restrict delete 
ccountrygroupfrom_ctax c_tax.c_countrygroupfrom_id c_countrygroup.c_countrygroup_id Restrict delete 
ccountrygroupto_ctax c_tax.c_countrygroupto_id c_countrygroup.c_countrygroup_id Restrict delete 
ccurrency_cbankaccount c_bankaccount.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_cconversionrate c_conversion_rate.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_ccountry c_country.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_celementvalue c_elementvalue.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_cproject c_project.c_currency_id c_currency.c_currency_id Restrict delete 
cdoctype_cdoctypecounter c_doctypecounter.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_invoice c_doctype.c_doctypeinvoice_id c_doctype.c_doctype_id Restrict delete 
cdoctype_proforma c_doctype.c_doctypeproforma_id c_doctype.c_doctype_id Restrict delete 
cdoctype_shipment c_doctype.c_doctypeshipment_id c_doctype.c_doctype_id Restrict delete 
cdoctypecount_cdoctypecount c_doctypecounter.counter_c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctypedifference_cdoctype c_doctype.c_doctypedifference_id c_doctype.c_doctype_id Restrict delete 
cdunning_cbpartner c_bpartner.c_dunning_id c_dunning.c_dunning_id Restrict delete 
celement_celementvalue c_elementvalue.c_element_id c_element.c_element_id Cascade on delete 
celementvalueaccount_vc c_validcombination.account_id c_elementvalue.c_elementvalue_id Cascade on delete 
celementvalueuser1_vc c_validcombination.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser2_vc c_validcombination.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
clocation_cbank c_bank.c_location_id c_location.c_location_id Restrict delete 
clocation_cbplocation c_bpartner_location.c_location_id c_location.c_location_id Restrict delete 
cpaymentterm_cbpartner c_bpartner.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpaymentterm_cproject c_project.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpaymentterm_cwithholding c_withholding.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cperiod_cacctschema c_acctschema.c_period_id c_period.c_period_id Restrict delete 
cpopaymentterm_cbpartner c_bpartner.po_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cproject_vc c_validcombination.c_project_id c_project.c_project_id Restrict delete 
cregion_ccity c_city.c_region_id c_region.c_region_id Restrict delete 
csalesregion_bpartnerlocation c_bpartner_location.c_salesregion_id c_salesregion.c_salesregion_id Null on delete 
csalesregion_vc c_validcombination.c_salesregion_id c_salesregion.c_salesregion_id Restrict delete 
ctax_parent c_tax.parent_tax_id c_tax.c_tax_id Restrict delete 
ctaxcategory_ctax c_tax.c_taxcategory_id c_taxcategory.c_taxcategory_id Cascade on delete 
ctaxcategory_mproduct m_product.c_taxcategory_id c_taxcategory.c_taxcategory_id Restrict delete 
cuom_cuomconversion c_uom_conversion.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_mproduct m_product.c_uom_id c_uom.c_uom_id Restrict delete 
cwithholding_cbpwithholding c_bp_withholding.c_withholding_id c_withholding.c_withholding_id Restrict delete 
mlocationfrom_vc c_validcombination.c_locfrom_id c_location.c_location_id Restrict delete 
mlocationto_vc c_validcombination.c_locto_id c_location.c_location_id Restrict delete 
mproduct_cuomconversion c_uom_conversion.m_product_id m_product.m_product_id Restrict delete 
mproduct_vc c_validcombination.m_product_id m_product.m_product_id Restrict delete 
mwarehouse_cproject c_project.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehousesource_mwarehouse m_warehouse.m_warehousesource_id m_warehouse.m_warehouse_id Restrict delete 
socampaign_vc c_validcombination.c_campaign_id c_campaign.c_campaign_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected