| SchemaSpy Analysis of idempiere11.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 | ||