SchemaSpy Analysis of idempiere11.adempiere - ConstraintsWebStore Generated by
Quality Systems & Solutions
59 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_user_client ad_user.ad_client_id ad_client.ad_client_id Restrict delete 
adclient_adclientinfo ad_clientinfo.ad_client_id ad_client.ad_client_id Cascade on delete 
adclient_cbpartner c_bpartner.ad_client_id ad_client.ad_client_id Restrict delete 
adclient_mproduct m_product.ad_client_id ad_client.ad_client_id Restrict delete 
adclient_wstore w_store.ad_client_id ad_client.ad_client_id Restrict delete 
adlangu_adclient ad_client.ad_language ad_language.ad_language Restrict delete 
adlanguage_wmailmsgtrl w_mailmsg_trl.ad_language ad_language.ad_language Cascade on delete 
aduser_adusermail ad_usermail.ad_user_id ad_user.ad_user_id Cascade on delete 
aduser_rrequest r_request.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_supervisor ad_user.supervisor_id ad_user.ad_user_id Restrict delete 
aduser_wadvertisement w_advertisement.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_wbasket w_basket.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_wclick w_click.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_wcounter w_counter.ad_user_id ad_user.ad_user_id Restrict delete 
adusersalesrep_cbpartner c_bpartner.salesrep_id ad_user.ad_user_id Null on delete 
adusersr_rrequest r_request.salesrep_id ad_user.ad_user_id Restrict delete 
basepricelist m_pricelist.basepricelist_id m_pricelist.m_pricelist_id Restrict delete 
c_bpartner_rrequest r_request.c_bpartner_id c_bpartner.c_bpartner_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 
cbpartner_wadvertisement w_advertisement.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_wbasket w_basket.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_wclickcount w_clickcount.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_wcountercount w_countercount.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnercashtrx_adclientinfo ad_clientinfo.c_bpartnercashtrx_id c_bpartner.c_bpartner_id Restrict delete 
cpaymentterm_cbpartner c_bpartner.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpaymentterm_wstore w_store.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpopaymentterm_cbpartner c_bpartner.po_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
languageclient ad_language.ad_client_id ad_client.ad_client_id Restrict delete 
m_warehouse_client m_warehouse.ad_client_id ad_client.ad_client_id Restrict delete 
mpricelist_cbpartner c_bpartner.m_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mpricelist_wbasket w_basket.m_pricelist_id m_pricelist.m_pricelist_id Restrict delete 
mpricelist_wstore w_store.m_pricelist_id m_pricelist.m_pricelist_id Restrict delete 
mpricelistpo_cbuspartner c_bpartner.po_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mproduct_rrequest r_request.m_product_id m_product.m_product_id Restrict delete 
mproduct_wbasketline w_basketline.m_product_id m_product.m_product_id Restrict delete 
mproductfreight_adclientinfo ad_clientinfo.m_productfreight_id m_product.m_product_id Restrict delete 
mproductspent_rrequest r_request.m_productspent_id m_product.m_product_id Restrict delete 
mwarehouse_wstore w_store.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehousesource_mwarehouse m_warehouse.m_warehousesource_id m_warehouse.m_warehouse_id Restrict delete 
rdefaultmailtext_aduser ad_user.r_defaultmailtext_id r_mailtext.r_mailtext_id Restrict delete 
rmailtext_adusermail ad_usermail.r_mailtext_id r_mailtext.r_mailtext_id Cascade on delete 
rmailtext_mproduct m_product.r_mailtext_id r_mailtext.r_mailtext_id Restrict delete 
rmailtext_rrequest r_request.r_mailtext_id r_mailtext.r_mailtext_id Restrict delete 
rrequest_related r_request.r_requestrelated_id r_request.r_request_id Restrict delete 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 
salesrep_mproduct m_product.salesrep_id ad_user.ad_user_id Restrict delete 
salesrep_wstore w_store.salesrep_id ad_user.ad_user_id Restrict delete 
wbasket_wbasketline w_basketline.w_basket_id w_basket.w_basket_id Restrict delete 
wclickcount_wadvertisement w_advertisement.w_clickcount_id w_clickcount.w_clickcount_id Restrict delete 
wclickcount_wclick w_click.w_clickcount_id w_clickcount.w_clickcount_id Cascade on delete 
wcountercount_wadvertisement w_advertisement.w_countercount_id w_countercount.w_countercount_id Restrict delete 
wcountercount_wcounter w_counter.w_countercount_id w_countercount.w_countercount_id Cascade on delete 
wmailmsg_adusermail ad_usermail.w_mailmsg_id w_mailmsg.w_mailmsg_id Cascade on delete 
wmailmsg_wmailmsgtrl w_mailmsg_trl.w_mailmsg_id w_mailmsg.w_mailmsg_id Cascade on delete 
wstore_wmailmsg w_mailmsg.w_store_id w_store.w_store_id Cascade on delete 
wstore_wstoretrl w_store_trl.w_store_id w_store.w_store_id Cascade on delete 
wstoretrl_adlangauge w_store_trl.ad_language ad_language.ad_language Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected