| 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 | ||