| 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 | ||