SchemaSpy Analysis of idempiere9.adempiere - ConstraintsApplication Dictionary Generated by
Quality Systems & Solutions
123 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
ad_column_ad_tab ad_tab.ad_column_id ad_column.ad_column_id Restrict delete 
ad_column_field ad_field.ad_column_id ad_column.ad_column_id Restrict delete 
ad_column_reftable_display ad_ref_table.ad_display ad_column.ad_column_id Restrict delete 
ad_column_reftable_id ad_ref_table.ad_key ad_column.ad_column_id Restrict delete 
ad_element_ad_column ad_column.ad_element_id ad_element.ad_element_id Restrict delete 
ad_reference_columndatatype ad_column.ad_reference_id ad_reference.ad_reference_id Restrict delete 
ad_reference_columnvalue ad_column.ad_reference_value_id ad_reference.ad_reference_id Restrict delete 
ad_reference_reflist ad_ref_list.ad_reference_id ad_reference.ad_reference_id Cascade on delete 
ad_reference_reftable ad_ref_table.ad_reference_id ad_reference.ad_reference_id Cascade on delete 
ad_tab_field ad_field.ad_tab_id ad_tab.ad_tab_id Cascade on delete 
ad_table_column ad_column.ad_table_id ad_table.ad_table_id Cascade on delete 
ad_table_tab ad_tab.ad_table_id ad_table.ad_table_id Restrict delete 
ad_valrule_column ad_column.ad_val_rule_id ad_val_rule.ad_val_rule_id Restrict delete 
ad_valrule_table ad_table.ad_val_rule_id ad_val_rule.ad_val_rule_id Restrict delete 
ad_window_tab ad_tab.ad_window_id ad_window.ad_window_id Cascade on delete 
ad_window_table ad_table.ad_window_id ad_window.ad_window_id Null on delete 
adattribute_adattributevalue ad_attribute_value.ad_attribute_id ad_attribute.ad_attribute_id Cascade on delete 
adcolumn_adindexcolumn ad_indexcolumn.ad_column_id ad_column.ad_column_id Restrict delete 
adcolumn_adsearchdefinition ad_searchdefinition.ad_column_id ad_column.ad_column_id Restrict delete 
adcolumn_adtabsortorder ad_tab.ad_columnsortorder_id ad_column.ad_column_id Restrict delete 
adcolumn_adtabsortyesno ad_tab.ad_columnsortyesno_id ad_column.ad_column_id Restrict delete 
add_table_reftable ad_ref_table.ad_table_id ad_table.ad_table_id Restrict delete 
adelement_adinfocolumn ad_infocolumn.ad_element_id ad_element.ad_element_id Restrict delete 
adelement_adprocesspara ad_process_para.ad_element_id ad_element.ad_element_id Restrict delete 
adelement_adreference ad_reference.ad_element_id ad_element.ad_element_id Restrict delete 
adfield_aduserdeffield ad_userdef_field.ad_field_id ad_field.ad_field_id Restrict delete 
adfieldgroup_adfield ad_field.ad_fieldgroup_id ad_fieldgroup.ad_fieldgroup_id Restrict delete 
adfieldgroup_adprocesspara ad_process_para.ad_fieldgroup_id ad_fieldgroup.ad_fieldgroup_id Restrict delete 
adfieldgroup_aduserdeffield ad_userdef_field.ad_fieldgroup_id ad_fieldgroup.ad_fieldgroup_id Restrict delete 
adfieldgroup_aduserdefprocpara ad_userdef_proc_parameter.ad_fieldgroup_id ad_fieldgroup.ad_fieldgroup_id Restrict delete 
adfieldstyle_adfield ad_field.ad_fieldstyle_id ad_style.ad_style_id Restrict delete 
adfieldstyle_adinfocolumn ad_infocolumn.ad_fieldstyle_id ad_style.ad_style_id Restrict delete 
adfieldstyle_aduserdeffield ad_userdef_field.ad_fieldstyle_id ad_style.ad_style_id Restrict delete 
adfieldstyle_aduserdefinfocolu ad_userdef_info_column.ad_fieldstyle_id ad_style.ad_style_id Restrict delete 
adinfocolumn_adinfoprocess ad_infoprocess.ad_infocolumn_id ad_infocolumn.ad_infocolumn_id Restrict delete 
adinfocolumn_aduserdefinfocolu ad_userdef_info_column.ad_infocolumn_id ad_infocolumn.ad_infocolumn_id Restrict delete 
adinforelated_aduserdefinforel ad_userdef_info_related.ad_inforelated_id ad_inforelated.ad_inforelated_id Restrict delete 
adinfowindow_adinfocolumn ad_infocolumn.ad_infowindow_id ad_infowindow.ad_infowindow_id Cascade on delete 
adinfowindow_adinfoprocess ad_infoprocess.ad_infowindow_id ad_infowindow.ad_infowindow_id Cascade on delete 
adinfowindow_adinforelated ad_inforelated.ad_infowindow_id ad_infowindow.ad_infowindow_id Restrict delete 
adinfowindow_adreftable ad_ref_table.ad_infowindow_id ad_infowindow.ad_infowindow_id Restrict delete 
adinfowindow_aduserdefinfo ad_userdef_info.ad_infowindow_id ad_infowindow.ad_infowindow_id Cascade on delete 
adlabelstyle_adfield ad_field.ad_labelstyle_id ad_style.ad_style_id Restrict delete 
adlabelstyle_aduserdeffield ad_userdef_field.ad_labelstyle_id ad_style.ad_style_id Restrict delete 
adlangu_aduserdefinfo ad_userdef_info.ad_language ad_language.ad_language Restrict delete 
adlangu_aduserdefwin ad_userdef_win.ad_language ad_language.ad_language Restrict delete 
adlanguage_aduserdefproc ad_userdef_proc.ad_language ad_language.ad_language Restrict delete 
admessage_adstatusline ad_statusline.ad_message_id ad_message.ad_message_id Restrict delete 
admessage_adtableindex ad_tableindex.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_adinfoprocess ad_infoprocess.ad_process_id ad_process.ad_process_id Restrict delete 
adprocess_adinfowindow ad_infowindow.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_adtab ad_tab.ad_process_id ad_process.ad_process_id Restrict delete 
adprocess_adtoolbarbutton ad_toolbarbutton.ad_process_id ad_process.ad_process_id Restrict delete 
adprocess_aduserdefproc ad_userdef_proc.ad_process_id ad_process.ad_process_id Restrict delete 
adprocess_aduserdeftab ad_userdef_tab.ad_process_id ad_process.ad_process_id Restrict delete 
adprocesspara_aduserdefprocpar ad_userdef_proc_parameter.ad_process_para_id ad_process_para.ad_process_para_id Restrict delete 
adreference_adattribute ad_attribute.ad_reference_id ad_reference.ad_reference_id Restrict delete 
adreference_adfield ad_field.ad_reference_id ad_reference.ad_reference_id Restrict delete 
adreference_adinfocolumn ad_infocolumn.ad_reference_id ad_reference.ad_reference_id Restrict delete 
adreference_adprocesspara ad_process_para.ad_reference_id ad_reference.ad_reference_id Restrict delete 
adreference_aduserdefcolumn ad_userdef_info_column.ad_reference_id ad_reference.ad_reference_id Restrict delete 
adreference_aduserdeffield ad_userdef_field.ad_reference_id ad_reference.ad_reference_id Restrict delete 
adreference_aduserdefprocparam ad_userdef_proc_parameter.ad_reference_id ad_reference.ad_reference_id Restrict delete 
adreferencesource_adrelationty ad_relationtype.ad_reference_source_id ad_reference.ad_reference_id Restrict delete 
adreferencetarget_adrelationty ad_relationtype.ad_reference_target_id ad_reference.ad_reference_id Restrict delete 
adreferencevalue_adattribute ad_attribute.ad_reference_value_id ad_reference.ad_reference_id Restrict delete 
adreferencevalue_adfield ad_field.ad_reference_value_id ad_reference.ad_reference_id Restrict delete 
adreferencevalue_adinfocolumn ad_infocolumn.ad_reference_value_id ad_reference.ad_reference_id Restrict delete 
adreferencevalue_adprocpara ad_process_para.ad_reference_value_id ad_reference.ad_reference_id Restrict delete 
adreferencevalue_aduserdeffiel ad_userdef_field.ad_reference_value_id ad_reference.ad_reference_id Restrict delete 
adreferencevalue_aduserdefinfo ad_userdef_info_column.ad_reference_value_id ad_reference.ad_reference_id Restrict delete 
adreferencevalue_aduserdefproc ad_userdef_proc_parameter.ad_reference_value_id ad_reference.ad_reference_id Restrict delete 
adrole_aduserdefinfo ad_userdef_info.ad_role_id ad_role.ad_role_id Cascade on delete 
adrole_aduserdefproc ad_userdef_proc.ad_role_id ad_role.ad_role_id Cascade on delete 
adrole_aduserdefwin ad_userdef_win.ad_role_id ad_role.ad_role_id Restrict delete 
adrule_adtablescriptvalidator ad_table_scriptvalidator.ad_rule_id ad_rule.ad_rule_id Restrict delete 
adstatusline_adstatuslineusedi ad_statuslineusedin.ad_statusline_id ad_statusline.ad_statusline_id Restrict delete 
adstyle_adstyleline ad_styleline.ad_style_id ad_style.ad_style_id Restrict delete 
adtab_adstatuslineusedin ad_statuslineusedin.ad_tab_id ad_tab.ad_tab_id Restrict delete 
adtab_adtabcustomization ad_tab_customization.ad_tab_id ad_tab.ad_tab_id Restrict delete 
adtab_adtoolbarbutton ad_toolbarbutton.ad_tab_id ad_tab.ad_tab_id Restrict delete 
adtab_aduserdeftab ad_userdef_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 
adtable_adattribute ad_attribute.ad_table_id ad_table.ad_table_id Cascade on delete 
adtable_adinfowindow ad_infowindow.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adsearchdefinition ad_searchdefinition.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adstatuslineusedin ad_statuslineusedin.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adtableindex ad_tableindex.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adtablescriptvalidator ad_table_scriptvalidator.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adviewcomponent ad_viewcomponent.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adzoomcondition ad_zoomcondition.ad_table_id ad_table.ad_table_id Restrict delete 
adtableindex_adindexcolumn ad_indexcolumn.ad_tableindex_id ad_tableindex.ad_tableindex_id Restrict delete 
aduserdefinfo_aduserdefinfocol ad_userdef_info_column.ad_userdef_info_id ad_userdef_info.ad_userdef_info_id Restrict delete 
aduserdefinfo_aduserdefinforel ad_userdef_info_related.ad_userdef_info_id ad_userdef_info.ad_userdef_info_id Restrict delete 
aduserdefproc_aduserdefprocpar ad_userdef_proc_parameter.ad_userdef_proc_id ad_userdef_proc.ad_userdef_proc_id Restrict delete 
aduserdeftab_aduserdeffield ad_userdef_field.ad_userdef_tab_id ad_userdef_tab.ad_userdef_tab_id Restrict delete 
aduserdefwin_aduserdeftab ad_userdef_tab.ad_userdef_win_id ad_userdef_win.ad_userdef_win_id Restrict delete 
advalrule_ad_processpara ad_process_para.ad_val_rule_id ad_val_rule.ad_val_rule_id Restrict delete 
advalrule_adattribute ad_attribute.ad_val_rule_id ad_val_rule.ad_val_rule_id Null on delete 
advalrule_adfield ad_field.ad_val_rule_id ad_val_rule.ad_val_rule_id Restrict delete 
advalrule_adinfocolumn ad_infocolumn.ad_val_rule_id ad_val_rule.ad_val_rule_id Restrict delete 
advalrule_aduserdeffield ad_userdef_field.ad_val_rule_id ad_val_rule.ad_val_rule_id Restrict delete 
advalrule_aduserdefinfocolumn ad_userdef_info_column.ad_val_rule_id ad_val_rule.ad_val_rule_id Restrict delete 
advalrule_aduserdefprocparamet ad_userdef_proc_parameter.ad_val_rule_id ad_val_rule.ad_val_rule_id Restrict delete 
advalrulelookup_adcolumn ad_column.ad_val_rule_lookup_id ad_val_rule.ad_val_rule_id Restrict delete 
advalrulelookup_adfield ad_field.ad_val_rule_lookup_id ad_val_rule.ad_val_rule_id Restrict delete 
advalrulelookup_aduserdeffield ad_userdef_field.ad_val_rule_lookup_id ad_val_rule.ad_val_rule_id Restrict delete 
adviewcomponent_adviewcolumn ad_viewcolumn.ad_viewcomponent_id ad_viewcomponent.ad_viewcomponent_id Restrict delete 
adwindow_adreftable ad_ref_table.ad_window_id ad_window.ad_window_id Restrict delete 
adwindow_adsearchdefinition ad_searchdefinition.ad_window_id ad_window.ad_window_id Restrict delete 
adwindow_adstatuslineusedin ad_statuslineusedin.ad_window_id ad_window.ad_window_id Restrict delete 
adwindow_aduserdefwin ad_userdef_win.ad_window_id ad_window.ad_window_id Restrict delete 
adwindow_adzoomcondition ad_zoomcondition.ad_window_id ad_window.ad_window_id Restrict delete 
adwindowpo_adtable ad_table.po_window_id ad_window.ad_window_id Restrict delete 
includedtab_adfield ad_field.included_tab_id ad_tab.ad_tab_id Restrict delete 
parentcolumn_adtab ad_tab.parent_column_id ad_column.ad_column_id Restrict delete 
parentrelatedcolumn_adinforela ad_inforelated.parentrelatedcolumn_id ad_infocolumn.ad_infocolumn_id Restrict delete 
powindow_adsearchdefinition ad_searchdefinition.po_window_id ad_window.ad_window_id Restrict delete 
referencedtable_adviewcomponen ad_viewcomponent.referenced_table_id ad_table.ad_table_id Restrict delete 
relatedcolumn_adinforelated ad_inforelated.relatedcolumn_id ad_infocolumn.ad_infocolumn_id Restrict delete 
relatedinfo_adinforelated ad_inforelated.relatedinfo_id ad_infowindow.ad_infowindow_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected