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 |