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

Constraint Name Child Column Parent Column Delete Rule
ad_table_column ad_column.ad_table_id ad_table.ad_table_id Cascade on delete 
ad_wfnodetrl ad_wf_node_trl.ad_wf_node_id ad_wf_node.ad_wf_node_id Cascade on delete 
ad_workflowtrl ad_workflow_trl.ad_workflow_id ad_workflow.ad_workflow_id Cascade on delete 
adattachment_note ad_attachmentnote.ad_attachment_id ad_attachment.ad_attachment_id Restrict delete 
adcolumn_adfind ad_find.ad_column_id ad_column.ad_column_id Restrict delete 
adcolumn_adwfnextcondition ad_wf_nextcondition.ad_column_id ad_column.ad_column_id Restrict delete 
adcolumn_adwfnode ad_wf_node.ad_column_id ad_column.ad_column_id Restrict delete 
adimage_aduser ad_user.ad_image_id ad_image.ad_image_id Restrict delete 
adimage_adwfnode ad_wf_node.ad_image_id ad_image.ad_image_id Restrict delete 
admessage_adnote ad_note.ad_message_id ad_message.ad_message_id Restrict delete 
admessage_adwfactivity ad_wf_activity.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 
adprocess_adcolumn ad_column.ad_process_id ad_process.ad_process_id Null on delete 
adprocess_adprocesspara ad_process_para.ad_process_id ad_process.ad_process_id Cascade on delete 
adprocess_adwfnode ad_wf_node.ad_process_id ad_process.ad_process_id Restrict delete 
adprocesspara_adwfnodepara ad_wf_node_para.ad_process_para_id ad_process_para.ad_process_para_id Cascade on delete 
adtable_adattachment ad_attachment.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_adwfactivity ad_wf_activity.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adwfeventaudit ad_wf_eventaudit.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 
aduser_adattachmentnote ad_attachmentnote.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adnote ad_note.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adwfactivity ad_wf_activity.ad_user_id ad_user.ad_user_id Null on delete 
aduser_adwfactivityapprover ad_wf_activityapprover.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adwfeventaudit ad_wf_eventaudit.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_adwfresponsible ad_wf_responsible.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adwizardprocess ad_wizardprocess.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adworkflowprocessor ad_workflowprocessor.supervisor_id ad_user.ad_user_id Restrict delete 
aduser_supervisor ad_user.supervisor_id ad_user.ad_user_id Restrict delete 
adwfactivity_adnote ad_note.ad_wf_activity_id ad_wf_activity.ad_wf_activity_id Restrict delete 
adwfactivity_adwfactivityappro ad_wf_activityapprover.ad_wf_activity_id ad_wf_activity.ad_wf_activity_id Cascade on delete 
adwfactivity_adwfactresult ad_wf_activityresult.ad_wf_activity_id ad_wf_activity.ad_wf_activity_id Cascade on delete 
adwfblock_adwfnode ad_wf_node.ad_wf_block_id ad_wf_block.ad_wf_block_id Null on delete 
adwfnode_adwfactivity ad_wf_activity.ad_wf_node_id ad_wf_node.ad_wf_node_id Cascade on delete 
adwfnode_adwfeventaudit ad_wf_eventaudit.ad_wf_node_id ad_wf_node.ad_wf_node_id Restrict delete 
adwfnode_adwfnodenext ad_wf_nodenext.ad_wf_node_id ad_wf_node.ad_wf_node_id Cascade on delete 
adwfnode_adwfnodepara ad_wf_node_para.ad_wf_node_id ad_wf_node.ad_wf_node_id Restrict delete 
adwfnode_adwizardprocess ad_wizardprocess.ad_wf_node_id ad_wf_node.ad_wf_node_id Restrict delete 
adwfnode_adworkflow ad_workflow.ad_wf_node_id ad_wf_node.ad_wf_node_id Restrict delete 
adwfnodenext_adwfnextcond ad_wf_nextcondition.ad_wf_nodenext_id ad_wf_nodenext.ad_wf_nodenext_id Cascade on delete 
adwfnodenext_adwfnodenext ad_wf_nodenext.ad_wf_next_id ad_wf_node.ad_wf_node_id Cascade on delete 
adwfproccess_adwfprocessdata ad_wf_processdata.ad_wf_process_id ad_wf_process.ad_wf_process_id Cascade on delete 
adwfprocess_adwfactivity ad_wf_activity.ad_wf_process_id ad_wf_process.ad_wf_process_id Cascade on delete 
adwfprocess_adwfeventaudit ad_wf_eventaudit.ad_wf_process_id ad_wf_process.ad_wf_process_id Restrict delete 
adwfprocess_adwfprocess ad_wf_process.ad_wf_process_id ad_wf_process.ad_wf_process_id Restrict delete 
adwfresponsib_adwfeventaudit ad_wf_eventaudit.ad_wf_responsible_id ad_wf_responsible.ad_wf_responsible_id Restrict delete 
adwfresponsible_adwfactivity ad_wf_activity.ad_wf_responsible_id ad_wf_responsible.ad_wf_responsible_id Null on delete 
adwfresponsible_adwfnode ad_wf_node.ad_wf_responsible_id ad_wf_responsible.ad_wf_responsible_id Restrict delete 
adwfresponsible_adwfprocess ad_wf_process.ad_wf_responsible_id ad_wf_responsible.ad_wf_responsible_id Restrict delete 
adwfresponsible_adworkflow ad_workflow.ad_wf_responsible_id ad_wf_responsible.ad_wf_responsible_id Restrict delete 
adworkflow_adprocess ad_process.ad_workflow_id ad_workflow.ad_workflow_id Restrict delete 
adworkflow_adwfactivity ad_wf_activity.ad_workflow_id ad_workflow.ad_workflow_id Restrict delete 
adworkflow_adwfblock ad_wf_block.ad_workflow_id ad_workflow.ad_workflow_id Cascade on delete 
adworkflow_adwfnode ad_wf_node.ad_workflow_id ad_workflow.ad_workflow_id Cascade on delete 
adworkflow_adwfnodesubflow ad_wf_node.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 
adworkfow_workflowaccess ad_workflow_access.ad_workflow_id ad_workflow.ad_workflow_id Cascade on delete 
fkconstraintmsg_adcolumn ad_column.fkconstraintmsg_id ad_message.ad_message_id Restrict delete 
rdefaultmailtext_aduser ad_user.r_defaultmailtext_id r_mailtext.r_mailtext_id Restrict delete 
rmailtext_adwfnode ad_wf_node.r_mailtext_id r_mailtext.r_mailtext_id Restrict delete 
rmailtext_rmailtexttrl r_mailtext_trl.r_mailtext_id r_mailtext.r_mailtext_id Cascade on delete 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected