SchemaSpy Analysis of idempiere11.adempiere - ConstraintsCountry etc Generated by
Quality Systems & Solutions
19 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
adlanguage_ccountry c_country.ad_language ad_language.ad_language Restrict delete 
c_country_location c_location.c_country_id c_country.c_country_id Restrict delete 
c_location_warehouse m_warehouse.c_location_id c_location.c_location_id Restrict delete 
c_region_location c_location.c_region_id c_region.c_region_id Restrict delete 
caddressvalidation_caddresstra c_addresstransaction.c_addressvalidation_id c_addressvalidation.c_addressvalidation_id Restrict delete 
caddressvalidation_clocation c_location.c_addressvalidation_id c_addressvalidation.c_addressvalidation_id Restrict delete 
caddressvalidationcfg_caddress c_addressvalidation.c_addressvalidationcfg_id c_addressvalidationcfg.c_addressvalidationcfg_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_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 
ccurrency_ccountry c_country.c_currency_id c_currency.c_currency_id Restrict delete 
clocation_caddresstransaction c_addresstransaction.c_location_id c_location.c_location_id Restrict delete 
cregion_ccity c_city.c_region_id c_region.c_region_id Restrict delete 
m_warehouse_locator m_locator.m_warehouse_id m_warehouse.m_warehouse_id Cascade on delete 
mreservelocator_mwarehouse m_warehouse.m_reservelocator_id m_locator.m_locator_id Restrict delete 
mwarehousesource_mwarehouse m_warehouse.m_warehousesource_id m_warehouse.m_warehouse_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected