SchemaSpy Analysis of idempiere9.adempiere - ConstraintsAccess and Security Generated by
Quality Systems & Solutions
89 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
ad_dataaccessorg ad_table_access.ad_org_id ad_org.ad_org_id Restrict delete 
ad_functaccessorg ad_window_access.ad_org_id ad_org.ad_org_id Restrict delete 
ad_processtaccess_org ad_process_access.ad_org_id ad_org.ad_org_id Restrict delete 
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_table_column ad_column.ad_table_id ad_table.ad_table_id Cascade on delete 
ad_taskaccess_org ad_task_access.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 
ad_window_table ad_table.ad_window_id ad_window.ad_window_id Null on delete 
adauthorizationcredential_adau ad_authorizationaccount.ad_authorizationcredential_id ad_authorizationcredential.ad_authorizationcredential_id Restrict delete 
adauthorizationprovauthscopepr ad_authorizationscopeprov.ad_authorizationprovider_id ad_authorizationprovider.ad_authorizationprovider_id Restrict delete 
adauthorizationprovider_adauth ad_authorizationcredential.ad_authorizationprovider_id ad_authorizationprovider.ad_authorizationprovider_id Restrict delete 
adcolumn_adchangelog ad_changelog.ad_column_id ad_column.ad_column_id Cascade on delete 
adcolumn_adcolumnaccess ad_column_access.ad_column_id ad_column.ad_column_id Restrict delete 
adform_adformaccess ad_form_access.ad_form_id ad_form.ad_form_id Cascade on delete 
adform_adprocess ad_process.ad_form_id ad_form.ad_form_id Restrict delete 
adorg_adimporttemplateaccess ad_importtemplateaccess.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_adpasswordhistory ad_password_history.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_adroleorgaccess ad_role_orgaccess.ad_org_id ad_org.ad_org_id Cascade on delete 
adorg_aduserorgaccess ad_user_orgaccess.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_padashboardcontentaccess pa_dashboardcontent_access.ad_org_id ad_org.ad_org_id Restrict delete 
adorgtrx_aduser ad_user.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adprocess_adcolumn ad_column.ad_process_id ad_process.ad_process_id Null on delete 
adprocess_adprocessaccess ad_process_access.ad_process_id ad_process.ad_process_id Cascade on delete 
adprocess_adtoolbarbuttonrestr ad_toolbarbuttonrestrict.ad_process_id ad_process.ad_process_id Restrict delete 
adrole_adcolumnaccess ad_column_access.ad_role_id ad_role.ad_role_id Restrict delete 
adrole_addocumentactionaccess ad_document_action_access.ad_role_id ad_role.ad_role_id Restrict delete 
adrole_adformaccess ad_form_access.ad_role_id ad_role.ad_role_id Cascade on delete 
adrole_adimporttemplateaccess ad_importtemplateaccess.ad_role_id ad_role.ad_role_id Restrict delete 
adrole_adinfowindowaccess ad_infowindow_access.ad_role_id ad_role.ad_role_id Restrict delete 
adrole_adprocessaccess ad_process_access.ad_role_id ad_role.ad_role_id Cascade on delete 
adrole_adroleorgaccess ad_role_orgaccess.ad_role_id ad_role.ad_role_id Cascade on delete 
adrole_adsession ad_session.ad_role_id ad_role.ad_role_id Restrict delete 
adrole_adtableaccess ad_table_access.ad_role_id ad_role.ad_role_id Cascade on delete 
adrole_adtaskaccess ad_task_access.ad_role_id ad_role.ad_role_id Cascade on delete 
adrole_adtoolbarbuttonrestrict ad_toolbarbuttonrestrict.ad_role_id ad_role.ad_role_id Restrict delete 
adrole_aduserroles ad_user_roles.ad_role_id ad_role.ad_role_id Cascade on delete 
adrole_adwindowaccess ad_window_access.ad_role_id ad_role.ad_role_id Cascade on delete 
adrole_ardecordaccess ad_record_access.ad_role_id ad_role.ad_role_id Restrict delete 
adrole_padashboardcontentacces pa_dashboardcontent_access.ad_role_id ad_role.ad_role_id Restrict delete 
adsession_adchangelog ad_changelog.ad_session_id ad_session.ad_session_id Restrict delete 
adtable_adattachment ad_attachment.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adchangelog ad_changelog.ad_table_id ad_table.ad_table_id Cascade on delete 
adtable_adcolumnaccess ad_column_access.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adprivateaccess ad_private_access.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adrecordaccess ad_record_access.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adtableaccess ad_table_access.ad_table_id ad_table.ad_table_id Cascade on delete 
adtable_adtree ad_tree.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adworkflow ad_workflow.ad_table_id ad_table.ad_table_id Restrict delete 
adtask_adtaskaccess ad_task_access.ad_task_id ad_task.ad_task_id Cascade on delete 
adtree_adrole ad_role.ad_tree_menu_id ad_tree.ad_tree_id Restrict delete 
adtreeorg_adrole ad_role.ad_tree_org_id ad_tree.ad_tree_id Restrict delete 
aduser_adauthorizationaccount ad_authorizationaccount.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adldapaccess ad_ldapaccess.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adpasswordhistory ad_password_history.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adprivateaccess ad_private_access.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_aduserorgaccess ad_user_orgaccess.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_mfaregistereddevice mfa_registereddevice.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_mfaregistration mfa_registration.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_padashboardcontentacces pa_dashboardcontent_access.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 
adusersupervisor_adrole ad_role.supervisor_id ad_user.ad_user_id Restrict delete 
adwindow_adtoolbarbuttonrestri ad_toolbarbuttonrestrict.ad_window_id ad_window.ad_window_id Restrict delete 
adwindow_adwindowaccess ad_window_access.ad_window_id ad_window.ad_window_id Cascade on delete 
adwindowpo_adtable ad_table.po_window_id ad_window.ad_window_id Restrict delete 
adworkflow_adprocess ad_process.ad_workflow_id ad_workflow.ad_workflow_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 
columnorg ad_column.ad_org_id ad_org.ad_org_id Restrict delete 
createdby_adimporttemplateacce ad_importtemplateaccess.createdby ad_user.ad_user_id Restrict delete 
createdby_adpasswordhistory ad_password_history.createdby ad_user.ad_user_id Restrict delete 
createdby_padashboardcontentac pa_dashboardcontent_access.createdby ad_user.ad_user_id Restrict delete 
mfamethod_mfaregistration mfa_registration.mfa_method_id mfa_method.mfa_method_id Restrict delete 
mfamethod_mfarule mfa_rule.mfa_method_id mfa_method.mfa_method_id Restrict delete 
parentcolumn_adtree ad_tree.parent_column_id ad_column.ad_column_id Restrict delete 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 
tableorg ad_table.ad_org_id ad_org.ad_org_id Restrict delete 
taskorg ad_task.ad_org_id ad_org.ad_org_id Restrict delete 
updatedby_adimporttemplateacce ad_importtemplateaccess.updatedby ad_user.ad_user_id Restrict delete 
updatedby_adpasswordhistory ad_password_history.updatedby ad_user.ad_user_id Restrict delete 
updatedby_padashboardcontentac pa_dashboardcontent_access.updatedby ad_user.ad_user_id Restrict delete 
windoworg ad_window.ad_org_id ad_org.ad_org_id Restrict delete 
workfloworg ad_workflow.ad_org_id ad_org.ad_org_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected