SchemaSpy Analysis of idempiere9.adempiere - ConstraintsUtility Generated by
Quality Systems & Solutions
55 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
ad_messagetrl ad_message_trl.ad_message_id ad_message.ad_message_id Cascade on delete 
ad_sequence_doctypedoc c_doctype.docnosequence_id ad_sequence.ad_sequence_id Restrict delete 
ad_sequence_sequenceaudit ad_sequence_audit.ad_sequence_id ad_sequence.ad_sequence_id Cascade on delete 
ad_sequence_sequenceno ad_sequence_no.ad_sequence_id ad_sequence.ad_sequence_id Cascade on delete 
ad_task_taskinstance ad_taskinstance.ad_task_id ad_task.ad_task_id Cascade on delete 
ad_valrule_table ad_table.ad_val_rule_id ad_val_rule.ad_val_rule_id Restrict delete 
ad_window_table ad_table.ad_window_id ad_window.ad_window_id Null on delete 
adcolor_adwindow ad_window.ad_color_id ad_color.ad_color_id Restrict delete 
adform_adissue ad_issue.ad_form_id ad_form.ad_form_id Null on delete 
adform_admenu ad_menu.ad_form_id ad_form.ad_form_id Restrict delete 
adform_adprocess ad_process.ad_form_id ad_form.ad_form_id Restrict delete 
adimage_adcolor ad_color.ad_image_id ad_image.ad_image_id Restrict delete 
adimage_adwindow ad_window.ad_image_id ad_image.ad_image_id Restrict delete 
adimpformat_adimpformatrow ad_impformat_row.ad_impformat_id ad_impformat.ad_impformat_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_adarchive ad_archive.ad_process_id ad_process.ad_process_id Restrict delete 
adprocess_adissue ad_issue.ad_process_id ad_process.ad_process_id Null on delete 
adprocess_admenu ad_menu.ad_process_id ad_process.ad_process_id Restrict 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 
adstorageprovider_adarchive ad_archive.ad_storageprovider_id ad_storageprovider.ad_storageprovider_id Restrict delete 
adstorageprovider_adattachment ad_attachment.ad_storageprovider_id ad_storageprovider.ad_storageprovider_id Restrict delete 
adstorageprovider_adimage ad_image.ad_storageprovider_id ad_storageprovider.ad_storageprovider_id Restrict delete 
adtable_adarchive ad_archive.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adattachment ad_attachment.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adimpformat ad_impformat.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_adpinstancelog ad_pinstance_log.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adrecentitem ad_recentitem.ad_table_id ad_table.ad_table_id Cascade on delete 
adtable_adsequenceaudit ad_sequence_audit.ad_table_id ad_table.ad_table_id Cascade on 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 
adtask_admenu ad_menu.ad_task_id ad_task.ad_task_id Restrict delete 
advalrule_ad_processpara ad_process_para.ad_val_rule_id ad_val_rule.ad_val_rule_id Restrict delete 
adwfprocess_adwfprocess ad_wf_process.ad_wf_process_id ad_wf_process.ad_wf_process_id Restrict delete 
adwindow_adissue ad_issue.ad_window_id ad_window.ad_window_id Null on delete 
adwindow_admenu ad_menu.ad_window_id ad_window.ad_window_id Restrict delete 
adwindow_adrecentitem ad_recentitem.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_admenu ad_menu.ad_workflow_id ad_workflow.ad_workflow_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 
c_uomconversionto c_uom_conversion.c_uom_to_id c_uom.c_uom_id Restrict delete 
cbpartner_adarchive ad_archive.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_id Restrict delete 
cdoctype_invoice c_doctype.c_doctypeinvoice_id c_doctype.c_doctype_id Restrict delete 
cdoctype_proforma c_doctype.c_doctypeproforma_id c_doctype.c_doctype_id Restrict delete 
cdoctype_shipment c_doctype.c_doctypeshipment_id c_doctype.c_doctype_id Restrict delete 
cdoctypedifference_cdoctype c_doctype.c_doctypedifference_id c_doctype.c_doctype_id Restrict delete 
cuom_cuomconversion c_uom_conversion.c_uom_id c_uom.c_uom_id Restrict delete 
definitesequence_cdoctype c_doctype.definitesequence_id ad_sequence.ad_sequence_id Restrict delete 
logo_cbpartner c_bpartner.logo_id ad_image.ad_image_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected