SchemaSpy Analysis of idempiere9.adempiere - ConstraintsClient & Organization Generated by
Quality Systems & Solutions
44 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
ad_language_c_buspartner c_bpartner.ad_language ad_language.ad_language Restrict delete 
ad_preference_client ad_preference.ad_client_id ad_client.ad_client_id Restrict delete 
ad_preference_org ad_preference.ad_org_id ad_org.ad_org_id Restrict delete 
ad_user_client ad_user.ad_client_id ad_client.ad_client_id Restrict delete 
ad_user_org ad_user.ad_org_id ad_org.ad_org_id Restrict delete 
ad_user_preference ad_preference.ad_user_id ad_user.ad_user_id Restrict delete 
adclient_adclientinfo ad_clientinfo.ad_client_id ad_client.ad_client_id Cascade on delete 
adclient_adclientshare ad_clientshare.ad_client_id ad_client.ad_client_id Restrict delete 
adclient_adorg ad_org.ad_client_id ad_client.ad_client_id Restrict delete 
adclient_adprintform ad_printform.ad_client_id ad_client.ad_client_id Restrict delete 
adclient_cbpartner c_bpartner.ad_client_id ad_client.ad_client_id Restrict delete 
adlangu_adclient ad_client.ad_language ad_language.ad_language Restrict delete 
adlanguage_ccountry c_country.ad_language ad_language.ad_language Restrict delete 
adorg_adclientshare ad_clientshare.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_adorginfo ad_orginfo.ad_org_id ad_org.ad_org_id Cascade on 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 
adorgparent_adorginfo ad_orginfo.parent_org_id ad_org.ad_org_id Null on delete 
adorgtrx_aduser ad_user.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtype_adorginfo ad_orginfo.ad_orgtype_id ad_orgtype.ad_orgtype_id Restrict delete 
adsystem_adregistration ad_registration.ad_system_id
ad_registration.ad_client_id
ad_system.ad_system_id
ad_system.ad_client_id
Restrict delete 
adtable_adclientshare ad_clientshare.ad_table_id ad_table.ad_table_id Restrict delete 
aduser_adorginfo ad_orginfo.supervisor_id ad_user.ad_user_id Null on 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 
basepricelist m_pricelist.basepricelist_id m_pricelist.m_pricelist_id Restrict delete 
c_countryclient c_country.ad_client_id ad_client.ad_client_id Restrict delete 
c_countryorg c_country.ad_org_id ad_org.ad_org_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 
cbpartnercashtrx_adclientinfo ad_clientinfo.c_bpartnercashtrx_id c_bpartner.c_bpartner_id Restrict delete 
ccountry_ccountry c_country.c_country_id c_country.c_country_id Restrict delete 
dropshipwarehouse_adorginfo ad_orginfo.dropship_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
languageclient ad_language.ad_client_id ad_client.ad_client_id Restrict delete 
languageorg ad_language.ad_org_id ad_org.ad_org_id Restrict delete 
m_warehouse_client m_warehouse.ad_client_id ad_client.ad_client_id Restrict delete 
m_warehouse_org m_warehouse.ad_org_id ad_org.ad_org_id Restrict delete 
mpricelist_cbpartner c_bpartner.m_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mpricelistpo_cbuspartner c_bpartner.po_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mwarehouse_adorginfo ad_orginfo.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehousesource_mwarehouse m_warehouse.m_warehousesource_id m_warehouse.m_warehouse_id Restrict delete 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 
tableclient ad_table.ad_client_id ad_client.ad_client_id Restrict delete 
tableorg ad_table.ad_org_id ad_org.ad_org_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected