SchemaSpy Analysis of idempiere9.adempiere - ConstraintsRequest Management Generated by
Quality Systems & Solutions
98 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
aasset_aassetdelivery a_asset_delivery.a_asset_id a_asset.a_asset_id Restrict delete 
aasset_rrequest r_request.a_asset_id a_asset.a_asset_id Restrict delete 
aasset_rrequestaction r_requestaction.a_asset_id a_asset.a_asset_id Restrict delete 
adrole_rrequest r_request.ad_role_id ad_role.ad_role_id Restrict delete 
adrole_rrequestaction r_requestaction.ad_role_id ad_role.ad_role_id Restrict delete 
adtable_rrequest r_request.ad_table_id ad_table.ad_table_id Restrict delete 
aduser_aasset a_asset.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_aassetdelivery a_asset_delivery.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adusermail ad_usermail.ad_user_id ad_user.ad_user_id Cascade on delete 
aduser_minout m_inout.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_rcategoryupdates r_categoryupdates.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_rcontactinterest r_contactinterest.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_rrequest r_request.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_rrequestaction r_requestaction.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_rrequestprocessor r_requestprocessor.supervisor_id ad_user.ad_user_id Restrict delete 
aduser_rrequestprocessorroute r_requestprocessor_route.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_rrequesttypeupdates r_requesttypeupdates.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_rrequestupdates r_requestupdates.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_ruserupdates r_groupupdates.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_sr_minout m_inout.salesrep_id ad_user.ad_user_id Restrict 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 
adusersr_rrequest r_request.salesrep_id ad_user.ad_user_id Restrict delete 
adusersr_rrequestaction r_requestaction.salesrep_id ad_user.ad_user_id Restrict delete 
adusersupervisor_adrole ad_role.supervisor_id ad_user.ad_user_id Restrict delete 
aparentasset_aasset a_asset.a_parent_asset_id a_asset.a_asset_id Restrict delete 
c_bpartner_rrequest r_request.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cactivity_aasset a_asset.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_minout m_inout.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_rrequest r_request.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_rrequestaction r_requestaction.c_activity_id c_activity.c_activity_id Restrict delete 
cbpartner_aasset a_asset.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_minout m_inout.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_mrma m_rma.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_rrequestaction r_requestaction.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnersr_aasset a_asset.c_bpartnersr_id c_bpartner.c_bpartner_id Restrict delete 
cbpgroup_cbpartner c_bpartner.c_bp_group_id c_bp_group.c_bp_group_id Restrict delete 
dropshipbpartner_minout m_inout.dropship_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
dropshipuser_minout m_inout.dropship_user_id ad_user.ad_user_id Restrict delete 
leasebpartner_aasset a_asset.lease_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
mchangenotice_rgroup r_group.m_changenotice_id m_changenotice.m_changenotice_id Restrict delete 
mchangerequest_rrequest r_request.m_changerequest_id m_changerequest.m_changerequest_id Restrict delete 
mcn_mcr m_changerequest.m_changenotice_id m_changenotice.m_changenotice_id Restrict delete 
mfixchangenotice_mchangereques m_changerequest.m_fixchangenotice_id m_changenotice.m_changenotice_id Restrict delete 
mfixchangenotice_rrequest r_request.m_fixchangenotice_id m_changenotice.m_changenotice_id Restrict delete 
minout_mrequestaction r_requestaction.m_inout_id m_inout.m_inout_id Restrict delete 
minout_mrma m_rma.inout_id m_inout.m_inout_id Restrict delete 
minout_ref m_inout.ref_inout_id m_inout.m_inout_id Restrict delete 
minout_rrequest r_request.m_inout_id m_inout.m_inout_id Restrict delete 
mproduct_aasset a_asset.m_product_id m_product.m_product_id Restrict delete 
mproduct_rcategory r_category.m_product_id m_product.m_product_id Restrict delete 
mproduct_rrequest r_request.m_product_id m_product.m_product_id Restrict delete 
mproduct_rrequestaction r_requestaction.m_product_id m_product.m_product_id Restrict delete 
mproductspent_rrequest r_request.m_productspent_id m_product.m_product_id Restrict delete 
mproductspent_rrequestaction r_requestaction.m_productspent_id m_product.m_product_id Restrict delete 
mproductspent_rrequestupdate r_requestupdate.m_productspent_id m_product.m_product_id Restrict delete 
mrma_minout m_inout.m_rma_id m_rma.m_rma_id Restrict delete 
mrma_rrequest r_request.m_rma_id m_rma.m_rma_id Restrict delete 
mrma_rrequestaction r_requestaction.m_rma_id m_rma.m_rma_id Restrict delete 
nextstatus_rstatus r_status.next_status_id r_status.r_status_id Restrict delete 
rcategory_rcategoryupdates r_categoryupdates.r_category_id r_category.r_category_id Restrict delete 
rcategory_rrequest r_request.r_category_id r_category.r_category_id Restrict delete 
rcategory_rrequestaction r_requestaction.r_category_id r_category.r_category_id Restrict delete 
rdefaultmailtext_aduser ad_user.r_defaultmailtext_id r_mailtext.r_mailtext_id Restrict delete 
refrma_mrma m_rma.ref_rma_id m_rma.m_rma_id Restrict delete 
returnbpartner_minout m_inout.returnbpartner_id c_bpartner.c_bpartner_id Restrict delete 
returnuser_minout m_inout.returnuser_id ad_user.ad_user_id Restrict delete 
reversal_minout m_inout.reversal_id m_inout.m_inout_id Restrict delete 
rgroup_rgroupupdates r_groupupdates.r_group_id r_group.r_group_id Restrict delete 
rgroup_rrequest r_request.r_group_id r_group.r_group_id Restrict delete 
rgroup_rrequestaction r_requestaction.r_group_id r_group.r_group_id Restrict delete 
rinterestarea_rcontactinterest r_contactinterest.r_interestarea_id r_interestarea.r_interestarea_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 
rrequest_rrequestaction r_requestaction.r_request_id r_request.r_request_id Restrict delete 
rrequest_rrequestupdate r_requestupdate.r_request_id r_request.r_request_id Restrict delete 
rrequest_rrupdates r_requestupdates.r_request_id r_request.r_request_id Restrict delete 
rrequestprocessor_route r_requestprocessor_route.r_requestprocessor_id r_requestprocessor.r_requestprocessor_id Restrict delete 
rrequesttype_rprocessorrule r_requestprocessor_route.r_requesttype_id r_requesttype.r_requesttype_id Restrict delete 
rrequesttype_rrequest r_request.r_requesttype_id r_requesttype.r_requesttype_id Restrict delete 
rrequesttype_rrequestaction r_requestaction.r_requesttype_id r_requesttype.r_requesttype_id Restrict delete 
rrequesttype_rrequestprocessor r_requestprocessor.r_requesttype_id r_requesttype.r_requesttype_id Restrict delete 
rrequesttype_rrtupdates r_requesttypeupdates.r_requesttype_id r_requesttype.r_requesttype_id Restrict delete 
rresolution_rrequest r_request.r_resolution_id r_resolution.r_resolution_id Restrict delete 
rresolution_rrequestaction r_requestaction.r_resolution_id r_resolution.r_resolution_id Restrict delete 
rstandardresponse_rrequest r_request.r_standardresponse_id r_standardresponse.r_standardresponse_id Restrict delete 
rstatus_rrequest r_request.r_status_id r_status.r_status_id Restrict delete 
rstatus_rrequestaction r_requestaction.r_status_id r_status.r_status_id Restrict delete 
rstatuscategory_rrequesttype r_requesttype.r_statuscategory_id r_statuscategory.r_statuscategory_id Restrict delete 
rstatuscategory_rstatus r_status.r_statuscategory_id r_statuscategory.r_statuscategory_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_mrma m_rma.salesrep_id ad_user.ad_user_id Restrict delete 
updatestatus_rstatus r_status.update_status_id r_status.r_status_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected