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

Constraint Name Child Column Parent Column Delete Rule
ad_role_included_parent ad_role_included.ad_role_id ad_role.ad_role_id Cascade on delete 
ad_role_included_role ad_role_included.included_role_id ad_role.ad_role_id Restrict delete 
ad_roleorg ad_role.ad_org_id ad_org.ad_org_id Restrict delete 
ad_user_org ad_user.ad_org_id ad_org.ad_org_id Restrict delete 
ad_userrolesorg ad_user_roles.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_adorginfo ad_orginfo.ad_org_id ad_org.ad_org_id Cascade on delete 
adorg_adroleorgaccess ad_role_orgaccess.ad_org_id ad_org.ad_org_id Cascade on delete 
adorg_adwfresponsible ad_wf_responsible.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_cbpartner c_bpartner.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_cbpartnerorg c_bpartner.ad_orgbp_id ad_org.ad_org_id Restrict delete 
adorg_corgassignment c_orgassignment.ad_org_id ad_org.ad_org_id Restrict delete 
adorgparent_adorginfo ad_orginfo.parent_org_id ad_org.ad_org_id Null on delete 
adorgtrx_aduser ad_user.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adrole_adroleorgaccess ad_role_orgaccess.ad_role_id ad_role.ad_role_id Cascade on delete 
adrole_aduserroles ad_user_roles.ad_role_id ad_role.ad_role_id Cascade on delete 
adrole_adwfresponsible ad_wf_responsible.ad_role_id ad_role.ad_role_id Restrict delete 
aduser_adorginfo ad_orginfo.supervisor_id ad_user.ad_user_id Null on delete 
aduser_adusersub ad_user_substitute.ad_user_id ad_user.ad_user_id Cascade on delete 
aduser_adwfresponsible ad_wf_responsible.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_cjobassignment c_jobassignment.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_corgassignment c_orgassignment.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_cuserremuneration c_userremuneration.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_supervisor ad_user.supervisor_id ad_user.ad_user_id Restrict delete 
aduser_userroles ad_user_roles.ad_user_id ad_user.ad_user_id Cascade on delete 
adusersalesrep_cbpartner c_bpartner.salesrep_id ad_user.ad_user_id Null on delete 
adusersub_ad_usersub ad_user_substitute.substitute_id ad_user.ad_user_id Cascade on delete 
adusersupervisor_adrole ad_role.supervisor_id ad_user.ad_user_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 
cjob_aduser ad_user.c_job_id c_job.c_job_id Restrict delete 
cjob_cjobassignment c_jobassignment.c_job_id c_job.c_job_id Restrict delete 
cjob_cjobremuneration c_jobremuneration.c_job_id c_job.c_job_id Restrict delete 
cjobcategory_cjob c_job.c_jobcategory_id c_jobcategory.c_jobcategory_id Restrict delete 
cremuneration_cjobrem c_jobremuneration.c_remuneration_id c_remuneration.c_remuneration_id Restrict delete 
cremuneration_cuserrem c_userremuneration.c_remuneration_id c_remuneration.c_remuneration_id Restrict delete 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected