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

Constraint Name Child Column Parent Column Delete Rule
ad_tab_field ad_field.ad_tab_id ad_tab.ad_tab_id Cascade on delete 
ad_window_tab ad_tab.ad_window_id ad_window.ad_window_id Cascade on delete 
adfield_aspclientexception asp_clientexception.ad_field_id ad_field.ad_field_id Restrict delete 
adfield_aspfield asp_field.ad_field_id ad_field.ad_field_id Restrict delete 
adform_adprocess ad_process.ad_form_id ad_form.ad_form_id Restrict delete 
adform_aspclientexception asp_clientexception.ad_form_id ad_form.ad_form_id Restrict delete 
adform_aspform asp_form.ad_form_id ad_form.ad_form_id Restrict delete 
adprocess_adprocesspara ad_process_para.ad_process_id ad_process.ad_process_id Cascade on delete 
adprocess_adtab ad_tab.ad_process_id ad_process.ad_process_id Restrict delete 
adprocess_aspclientexception asp_clientexception.ad_process_id ad_process.ad_process_id Restrict delete 
adprocess_aspprocess asp_process.ad_process_id ad_process.ad_process_id Restrict delete 
adprocesspara_aspclientexcepti asp_clientexception.ad_process_para_id ad_process_para.ad_process_para_id Restrict delete 
adprocesspara_aspprocesspara asp_process_para.ad_process_para_id ad_process_para.ad_process_para_id Restrict delete 
adreflist_aspreflist asp_ref_list.ad_ref_list_id ad_ref_list.ad_ref_list_id Restrict delete 
adtab_adtabcustomization ad_tab_customization.ad_tab_id ad_tab.ad_tab_id Restrict delete 
adtab_aspclientexception asp_clientexception.ad_tab_id ad_tab.ad_tab_id Restrict delete 
adtab_asptab asp_tab.ad_tab_id ad_tab.ad_tab_id Restrict delete 
adtab_included ad_tab.included_tab_id ad_tab.ad_tab_id Restrict delete 
adtask_aspclientexception asp_clientexception.ad_task_id ad_task.ad_task_id Restrict delete 
adtask_asptask asp_task.ad_task_id ad_task.ad_task_id Restrict delete 
adwindow_aspclientexception asp_clientexception.ad_window_id ad_window.ad_window_id Restrict delete 
adwindow_aspwindow asp_window.ad_window_id ad_window.ad_window_id Restrict delete 
adworkflow_adprocess ad_process.ad_workflow_id ad_workflow.ad_workflow_id Restrict delete 
adworkflow_aspclientexception asp_clientexception.ad_workflow_id ad_workflow.ad_workflow_id Restrict delete 
adworkflow_aspworkflow asp_workflow.ad_workflow_id ad_workflow.ad_workflow_id Restrict delete 
asplevel_aspclientlevel asp_clientlevel.asp_level_id asp_level.asp_level_id Restrict delete 
asplevel_aspform asp_form.asp_level_id asp_level.asp_level_id Restrict delete 
asplevel_aspprocess asp_process.asp_level_id asp_level.asp_level_id Restrict delete 
asplevel_aspreflist asp_ref_list.asp_level_id asp_level.asp_level_id Restrict delete 
asplevel_asptask asp_task.asp_level_id asp_level.asp_level_id Restrict delete 
asplevel_aspwindow asp_window.asp_level_id asp_level.asp_level_id Restrict delete 
asplevel_aspworkflow asp_workflow.asp_level_id asp_level.asp_level_id Restrict delete 
aspmodule_aspclientlevel asp_clientlevel.asp_module_id asp_module.asp_module_id Restrict delete 
aspmodule_asplevel asp_level.asp_module_id asp_module.asp_module_id Restrict delete 
aspprocess_aspprocesspara asp_process_para.asp_process_id asp_process.asp_process_id Restrict delete 
asptab_aspfield asp_field.asp_tab_id asp_tab.asp_tab_id Restrict delete 
aspwindow_asptab asp_tab.asp_window_id asp_window.asp_window_id Restrict delete 
includedtab_adfield ad_field.included_tab_id ad_tab.ad_tab_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected