SchemaSpy Analysis of idempiere9.adempiere - ConstraintsHelp Generated by
Quality Systems & Solutions
36 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
aasset_adissue ad_issue.a_asset_id a_asset.a_asset_id Null on delete 
aasset_aregistration a_registration.a_asset_id a_asset.a_asset_id Restrict delete 
aasset_rissueproject r_issueproject.a_asset_id a_asset.a_asset_id Restrict delete 
aasset_rissuesystem r_issuesystem.a_asset_id a_asset.a_asset_id Restrict delete 
aasset_rrequest r_request.a_asset_id a_asset.a_asset_id Restrict delete 
aassetgroup_aasset a_asset.a_asset_group_id a_asset_group.a_asset_group_id Restrict delete 
adctxhelp_adctxhelpmsg ad_ctxhelpmsg.ad_ctxhelp_id ad_ctxhelp.ad_ctxhelp_id Restrict delete 
adctxhelp_adform ad_form.ad_ctxhelp_id ad_ctxhelp.ad_ctxhelp_id Restrict delete 
adctxhelp_adprocess ad_process.ad_ctxhelp_id ad_ctxhelp.ad_ctxhelp_id Restrict delete 
adform_adissue ad_issue.ad_form_id ad_form.ad_form_id Null on delete 
adform_adprocess ad_process.ad_form_id ad_form.ad_form_id Restrict delete 
adprocess_adissue ad_issue.ad_process_id ad_process.ad_process_id Null on 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 
aduser_aasset a_asset.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_aregistration a_registration.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_cproject c_project.ad_user_id ad_user.ad_user_id Null on delete 
aduser_rissueuser r_issueuser.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_sr_cproject c_project.salesrep_id ad_user.ad_user_id Restrict delete 
aduser_supervisor ad_user.supervisor_id ad_user.ad_user_id Restrict delete 
adusersr_rrequest r_request.salesrep_id ad_user.ad_user_id Restrict delete 
adwindow_adissue ad_issue.ad_window_id ad_window.ad_window_id Null on delete 
aparentasset_aasset a_asset.a_parent_asset_id a_asset.a_asset_id Restrict delete 
cproject_aasset a_asset.c_project_id c_project.c_project_id Restrict delete 
cproject_rissueproject r_issueproject.c_project_id c_project.c_project_id Restrict delete 
cproject_rrequest r_request.c_project_id c_project.c_project_id Restrict delete 
rissueproject_adissue ad_issue.r_issueproject_id r_issueproject.r_issueproject_id Restrict delete 
rissuerecommendation_rissuekno r_issueknown.r_issuerecommendation_id r_issuerecommendation.r_issuerecommendation_id Restrict delete 
rissuestatus_rissueknown r_issueknown.r_issuestatus_id r_issuestatus.r_issuestatus_id Restrict delete 
rissuesystem_ad_issue ad_issue.r_issuesystem_id r_issuesystem.r_issuesystem_id Restrict delete 
rissueuser_adissue ad_issue.r_issueuser_id r_issueuser.r_issueuser_id Restrict delete 
rknownissue_adissue ad_issue.r_issueknown_id r_issueknown.r_issueknown_id Restrict delete 
rrequest_adissue ad_issue.r_request_id r_request.r_request_id Null on delete 
rrequest_related r_request.r_requestrelated_id r_request.r_request_id Restrict delete 
rrequest_rissueknown r_issueknown.r_request_id r_request.r_request_id Restrict delete 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected