SchemaSpy Analysis of idempiere11.adempiere - ConstraintsTrees Generated by
Quality Systems & Solutions
30 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
admenu_adtreefavoritenode ad_tree_favorite_node.ad_menu_id ad_menu.ad_menu_id Restrict delete 
adtree_adtreebar ad_treebar.ad_tree_id ad_tree.ad_tree_id Cascade on delete 
adtree_adtreenode ad_treenode.ad_tree_id ad_tree.ad_tree_id Cascade on delete 
adtree_adtreenodebp ad_treenodebp.ad_tree_id ad_tree.ad_tree_id Cascade on delete 
adtree_adtreenodemm ad_treenodemm.ad_tree_id ad_tree.ad_tree_id Cascade on delete 
adtree_adtreenodepr ad_treenodepr.ad_tree_id ad_tree.ad_tree_id Cascade on delete 
adtree_adtreenodeu1 ad_treenodeu1.ad_tree_id ad_tree.ad_tree_id Cascade on delete 
adtree_adtreenodeu2 ad_treenodeu2.ad_tree_id ad_tree.ad_tree_id Cascade on delete 
adtree_adtreenodeu3 ad_treenodeu3.ad_tree_id ad_tree.ad_tree_id Cascade on delete 
adtree_adtreenodeu4 ad_treenodeu4.ad_tree_id ad_tree.ad_tree_id Cascade on delete 
adtree_celement c_element.ad_tree_id ad_tree.ad_tree_id Null on delete 
adtreeactivity_adclientinfo ad_clientinfo.ad_tree_activity_id ad_tree.ad_tree_id Restrict delete 
adtreebpartner_adclientinfo ad_clientinfo.ad_tree_bpartner_id ad_tree.ad_tree_id Restrict delete 
adtreecampaign_adclientinfo ad_clientinfo.ad_tree_campaign_id ad_tree.ad_tree_id Restrict delete 
adtreefavorite_adtreefavoriten ad_tree_favorite_node.ad_tree_favorite_id ad_tree_favorite.ad_tree_favorite_id Restrict delete 
adtreemenu_adclientinfo ad_clientinfo.ad_tree_menu_id ad_tree.ad_tree_id Restrict delete 
adtreeorg_adclientinfo ad_clientinfo.ad_tree_org_id ad_tree.ad_tree_id Restrict delete 
adtreeproduct_adclientinfo ad_clientinfo.ad_tree_product_id ad_tree.ad_tree_id Restrict delete 
adtreeproject_adclientinfo ad_clientinfo.ad_tree_project_id ad_tree.ad_tree_id Restrict delete 
adtreesalesreg_adclientinfo ad_clientinfo.ad_tree_salesregion_id ad_tree.ad_tree_id Restrict delete 
cactivity_cproject c_project.c_activity_id c_activity.c_activity_id Restrict delete 
cbpartner_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cproject c_project.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnercashtrx_adclientinfo ad_clientinfo.c_bpartnercashtrx_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnersr_cproject c_project.c_bpartnersr_id c_bpartner.c_bpartner_id Restrict delete 
celement_celementvalue c_elementvalue.c_element_id c_element.c_element_id Cascade on delete 
mproduct_mproductcategory m_product.m_product_category_id m_product_category.m_product_category_id Restrict delete 
mproductcat_parentcat m_product_category.m_product_category_parent_id m_product_category.m_product_category_id Restrict delete 
mproductfreight_adclientinfo ad_clientinfo.m_productfreight_id m_product.m_product_id Restrict delete 
parent_adtreefavoritenode ad_tree_favorite_node.parent_id ad_tree_favorite_node.ad_tree_favorite_node_id Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected