SchemaSpy Analysis of idempiere11.adempiere - ConstraintsServer Generated by
Quality Systems & Solutions
67 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
ad_client_c_acctschema c_acctschema.ad_client_id ad_client.ad_client_id Restrict delete 
ad_roleclient ad_role.ad_client_id ad_client.ad_client_id Restrict delete 
ad_user_client ad_user.ad_client_id ad_client.ad_client_id Restrict delete 
adalert_adalertrecipient ad_alertrecipient.ad_alert_id ad_alert.ad_alert_id Restrict delete 
adaltert_aralertrule ad_alertrule.ad_alert_id ad_alert.ad_alert_id Restrict delete 
adbroadcastmessage_adnote ad_note.ad_broadcastmessage_id ad_broadcastmessage.ad_broadcastmessage_id Restrict delete 
adclient_adclientinfo ad_clientinfo.ad_client_id ad_client.ad_client_id Cascade on delete 
admessage_adnote ad_note.ad_message_id ad_message.ad_message_id Restrict delete 
admessage_adwfprocess ad_wf_process.ad_message_id ad_message.ad_message_id Restrict delete 
adpinstance_adpinstancepara ad_pinstance_para.ad_pinstance_id ad_pinstance.ad_pinstance_id Cascade on delete 
adpinstance_pilog ad_pinstance_log.ad_pinstance_id ad_pinstance.ad_pinstance_id Cascade on delete 
adprocess_adissue ad_issue.ad_process_id ad_process.ad_process_id Null on delete 
adprocess_adpinstance ad_pinstance.ad_process_id ad_process.ad_process_id Restrict delete 
adprocess_adprocesspara ad_process_para.ad_process_id ad_process.ad_process_id Cascade on delete 
adprocess_adscheduler ad_scheduler.ad_process_id ad_process.ad_process_id Cascade on delete 
adprocesspara_adschedulerpara ad_scheduler_para.ad_process_para_id ad_process_para.ad_process_para_id Cascade on delete 
adrole_adaltertrecipient ad_alertrecipient.ad_role_id ad_role.ad_role_id Restrict delete 
adrole_adbroadcastmessage ad_broadcastmessage.ad_role_id ad_role.ad_role_id Restrict delete 
adrole_adschedulerrecipient ad_schedulerrecipient.ad_role_id ad_role.ad_role_id Restrict delete 
adschedule_adalertprocessor ad_alertprocessor.ad_schedule_id ad_schedule.ad_schedule_id Restrict delete 
adschedule_adscheduler ad_scheduler.ad_schedule_id ad_schedule.ad_schedule_id Restrict delete 
adschedule_adworkflowprocessor ad_workflowprocessor.ad_schedule_id ad_schedule.ad_schedule_id Restrict delete 
adschedule_cacctprocessor c_acctprocessor.ad_schedule_id ad_schedule.ad_schedule_id Restrict delete 
adschedule_rrequestprocessor r_requestprocessor.ad_schedule_id ad_schedule.ad_schedule_id Restrict delete 
adscheduler_adschedulerpara ad_scheduler_para.ad_scheduler_id ad_scheduler.ad_scheduler_id Cascade on delete 
adscheduler_log ad_schedulerlog.ad_scheduler_id ad_scheduler.ad_scheduler_id Cascade on delete 
adscheduler_recipient ad_schedulerrecipient.ad_scheduler_id ad_scheduler.ad_scheduler_id Restrict delete 
adtable_adaltertrule ad_alertrule.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adhousekeeping ad_housekeeping.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adnote ad_note.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adpinstance ad_pinstance.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adpinstancelog ad_pinstance_log.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adscheduler ad_scheduler.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adwfprocess ad_wf_process.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adworkflow ad_workflow.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_cacctprocessor c_acctprocessor.ad_table_id ad_table.ad_table_id Restrict delete 
aduser_adalertrecipient ad_alertrecipient.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adbroadcastmessage ad_broadcastmessage.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adldapprocessor ad_ldapprocessor.supervisor_id ad_user.ad_user_id Restrict delete 
aduser_adnote ad_note.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adscheduler ad_scheduler.supervisor_id ad_user.ad_user_id Restrict delete 
aduser_adschedulerrecipient ad_schedulerrecipient.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adwfprocess ad_wf_process.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adworkflowprocessor ad_workflowprocessor.supervisor_id ad_user.ad_user_id Restrict delete 
aduser_cacctprocessor c_acctprocessor.supervisor_id ad_user.ad_user_id Restrict delete 
aduser_calertprocessor ad_alertprocessor.supervisor_id ad_user.ad_user_id Restrict delete 
aduser_pinstance ad_pinstance.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_rrequestprocessor r_requestprocessor.supervisor_id ad_user.ad_user_id Restrict delete 
aduser_supervisor ad_user.supervisor_id ad_user.ad_user_id Restrict delete 
adusersupervisor_adrole ad_role.supervisor_id ad_user.ad_user_id Restrict delete 
adwfprocess_adwfprocess ad_wf_process.ad_wf_process_id ad_wf_process.ad_wf_process_id Restrict delete 
adworkflow_adprocess ad_process.ad_workflow_id ad_workflow.ad_workflow_id Restrict delete 
adworkflow_adwfprocess ad_wf_process.ad_workflow_id ad_workflow.ad_workflow_id Cascade on delete 
adworkflowprocessor_adwf ad_workflow.ad_workflowprocessor_id ad_workflowprocessor.ad_workflowprocessor_id Null on delete 
adworkflowprocessor_log ad_workflowprocessorlog.ad_workflowprocessor_id ad_workflowprocessor.ad_workflowprocessor_id Cascade on delete 
cacctprocessor_log c_acctprocessorlog.c_acctprocessor_id c_acctprocessor.c_acctprocessor_id Cascade on delete 
cacctschema1_adclientinfo ad_clientinfo.c_acctschema1_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_cacctprocessor c_acctprocessor.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
calertprocessor_adalert ad_alert.ad_alertprocessor_id ad_alertprocessor.ad_alertprocessor_id Null on delete 
calertprocessor_log ad_alertprocessorlog.ad_alertprocessor_id ad_alertprocessor.ad_alertprocessor_id Cascade on delete 
messageclient ad_message.ad_client_id ad_client.ad_client_id Restrict delete 
notificationclient_adbroadcast ad_broadcastmessage.notification_client_id ad_client.ad_client_id Restrict delete 
rrequestprocessor_log r_requestprocessorlog.r_requestprocessor_id r_requestprocessor.r_requestprocessor_id Cascade on delete 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 
tableclient ad_table.ad_client_id ad_client.ad_client_id Restrict delete 
wf_instanceclient ad_wf_process.ad_client_id ad_client.ad_client_id Restrict delete 
workflowclient ad_workflow.ad_client_id ad_client.ad_client_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected