SchemaSpy Analysis of idempiere11.adempiere - ConstraintsFinancial Reporting Generated by
Quality Systems & Solutions
25 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
ad_pinstance_t_trialbalance t_trialbalance.ad_pinstance_id ad_pinstance.ad_pinstance_id Cascade on delete 
adpinstance_treport t_report.ad_pinstance_id ad_pinstance.ad_pinstance_id Cascade on delete 
adpinstance_treportstatement t_reportstatement.ad_pinstance_id ad_pinstance.ad_pinstance_id Cascade on delete 
adprintformat_adpinstance ad_pinstance.ad_printformat_id ad_printformat.ad_printformat_id Restrict delete 
adprintformat_pareport pa_report.ad_printformat_id ad_printformat.ad_printformat_id Null on delete 
adtree_celement c_element.ad_tree_id ad_tree.ad_tree_id Null on delete 
adtreeaccount_pahierarchy pa_hierarchy.ad_tree_account_id ad_tree.ad_tree_id Restrict delete 
adtreeactivity_pahierarchy pa_hierarchy.ad_tree_activity_id ad_tree.ad_tree_id Restrict delete 
adtreebpartner_pahierarchy pa_hierarchy.ad_tree_bpartner_id ad_tree.ad_tree_id Restrict delete 
adtreecampaign_pahierarchy pa_hierarchy.ad_tree_campaign_id ad_tree.ad_tree_id Restrict delete 
adtreeorg_pahierarchy pa_hierarchy.ad_tree_org_id ad_tree.ad_tree_id Restrict delete 
adtreeproduct_pahierarchy pa_hierarchy.ad_tree_product_id ad_tree.ad_tree_id Restrict delete 
adtreeproject_pahierarchy pa_hierarchy.ad_tree_project_id ad_tree.ad_tree_id Restrict delete 
adtreesr_pahierarchy pa_hierarchy.ad_tree_salesregion_id ad_tree.ad_tree_id Restrict delete 
pareport_columnset pa_report.pa_reportcolumnset_id pa_reportcolumnset.pa_reportcolumnset_id Restrict delete 
pareport_lineset pa_report.pa_reportlineset_id pa_reportlineset.pa_reportlineset_id Restrict delete 
pareportcolumn_oper1 pa_reportcolumn.oper_1_id pa_reportcolumn.pa_reportcolumn_id Null on delete 
pareportcolumn_oper2 pa_reportcolumn.oper_2_id pa_reportcolumn.pa_reportcolumn_id Null on delete 
pareportcolumnset_column pa_reportcolumn.pa_reportcolumnset_id pa_reportcolumnset.pa_reportcolumnset_id Cascade on delete 
pareportline_oper1 pa_reportline.oper_1_id pa_reportline.pa_reportline_id Null on delete 
pareportline_oper2 pa_reportline.oper_2_id pa_reportline.pa_reportline_id Null on delete 
pareportline_parent pa_reportline.parent_id pa_reportline.pa_reportline_id Null on delete 
pareportline_pareportsource pa_reportsource.pa_reportline_id pa_reportline.pa_reportline_id Cascade on delete 
pareportline_treport t_report.pa_reportline_id pa_reportline.pa_reportline_id Cascade on delete 
pareportlineset_line pa_reportline.pa_reportlineset_id pa_reportlineset.pa_reportlineset_id Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected