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 |