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

Constraint Name Child Column Parent Column Delete Rule
c_buspartner_fact_acct fact_acct.c_bpartner_id c_bpartner.c_bpartner_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_currency_fact_acct fact_acct.c_currency_id c_currency.c_currency_id Restrict delete 
c_locationfrom_fact_acct fact_acct.c_locfrom_id c_location.c_location_id Restrict delete 
c_locationto_fact_acct fact_acct.c_locto_id c_location.c_location_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 
cacctschema_ctaxacct c_tax_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_ctaxdeclacct c_taxdeclarationacct.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 
callocation_callocationline c_allocationline.c_allocationhdr_id c_allocationhdr.c_allocationhdr_id Restrict delete 
callocationline_ctaxdeclline c_taxdeclarationline.c_allocationline_id c_allocationline.c_allocationline_id Restrict delete 
cbpartner_callocationline c_allocationline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_ccharge c_charge.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cinvoice c_invoice.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_ctaxdeclline c_taxdeclarationline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
ccharge_callocationline c_allocationline.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_cinvoice c_invoice.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_cinvoiceline c_invoiceline.c_charge_id c_charge.c_charge_id Restrict delete 
ccountry_ccountry c_country.c_country_id c_country.c_country_id Restrict delete 
ccountry_cregion c_region.c_country_id c_country.c_country_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_callocation c_allocationhdr.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_cinvoice c_invoice.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_ctaxdeclline c_taxdeclarationline.c_currency_id c_currency.c_currency_id Restrict delete 
cinvoice_callocationline c_allocationline.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_cinvoiceline c_invoiceline.c_invoice_id c_invoice.c_invoice_id Cascade on delete 
cinvoice_cinvoicetax c_invoicetax.c_invoice_id c_invoice.c_invoice_id Cascade on delete 
cinvoice_ctaxdeclline c_taxdeclarationline.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_ref c_invoice.ref_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoiceline_ctaxdeclline c_taxdeclarationline.c_invoiceline_id c_invoiceline.c_invoiceline_id Restrict delete 
convoiceline_ref c_invoiceline.ref_invoiceline_id c_invoiceline.c_invoiceline_id Restrict delete 
ctax_cinvoiceline c_invoiceline.c_tax_id c_tax.c_tax_id Restrict delete 
ctax_cinvoicetax c_invoicetax.c_tax_id c_tax.c_tax_id Restrict delete 
ctax_ctaxacct c_tax_acct.c_tax_id c_tax.c_tax_id Cascade on delete 
ctax_ctaxdeclline c_taxdeclarationline.c_tax_id c_tax.c_tax_id Restrict delete 
ctax_ctaxpostal c_taxpostal.c_tax_id c_tax.c_tax_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 
ctaxcategory_ccharge c_charge.c_taxcategory_id c_taxcategory.c_taxcategory_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 
ctaxdecl_ctaxdeclacct c_taxdeclarationacct.c_taxdeclaration_id c_taxdeclaration.c_taxdeclaration_id Restrict delete 
ctaxdeclaration_ctaxdeclline c_taxdeclarationline.c_taxdeclaration_id c_taxdeclaration.c_taxdeclaration_id Cascade on delete 
ctaxprovider_cinvoicetax c_invoicetax.c_taxprovider_id c_taxprovider.c_taxprovider_id Restrict delete 
ctaxprovider_ctax c_tax.c_taxprovider_id c_taxprovider.c_taxprovider_id Restrict delete 
ctaxprovidercfg_ctaxprovider c_taxprovider.c_taxprovidercfg_id c_taxprovidercfg.c_taxprovidercfg_id Restrict delete 
factacct_ctaxdeclacct c_taxdeclarationacct.fact_acct_id fact_acct.fact_acct_id Cascade on delete 
m_product_fact_acct fact_acct.m_product_id m_product.m_product_id Restrict delete 
mproduct_cinvoiceline c_invoiceline.m_product_id m_product.m_product_id Restrict delete 
relatedinvoice_cinvoice c_invoice.relatedinvoice_id c_invoice.c_invoice_id Restrict delete 
reversal_callocationhdr c_allocationhdr.reversal_id c_allocationhdr.c_allocationhdr_id Restrict delete 
reversal_cinvoice c_invoice.reversal_id c_invoice.c_invoice_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected