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

Constraint Name Child Column Parent Column Delete Rule
aasset_cinvoiceline c_invoiceline.a_asset_id a_asset.a_asset_id Restrict delete 
aparentasset_aasset a_asset.a_parent_asset_id a_asset.a_asset_id Restrict delete 
c_projectphase_minoutline m_inoutline.c_projectphase_id c_projectphase.c_projectphase_id Restrict delete 
cactivity_aasset a_asset.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_cinvoice c_invoice.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_cinvoiceline c_invoiceline.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_corder c_order.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_corderline c_orderline.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_cproject c_project.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_minout m_inout.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_minoutline m_inoutline.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_stimeexpenseline s_timeexpenseline.c_activity_id c_activity.c_activity_id Restrict delete 
cbpartner_aasset a_asset.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cinvoice c_invoice.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_corder c_order.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cproject c_project.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_minout m_inout.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_soline c_orderline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_stimeexpenseline s_timeexpenseline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnerbill_corder c_order.bill_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnerpay_corder c_order.pay_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnersr_aasset a_asset.c_bpartnersr_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnersr_cproject c_project.c_bpartnersr_id c_bpartner.c_bpartner_id Restrict delete 
ccycle_ccyclestep c_cyclestep.c_cycle_id c_cycle.c_cycle_id Cascade on delete 
ccyclestep_ccyclephase c_cyclephase.c_cyclestep_id c_cyclestep.c_cyclestep_id Cascade on delete 
cinvoice_cinvoiceline c_invoiceline.c_invoice_id c_invoice.c_invoice_id Cascade on delete 
cinvoice_minout m_inout.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_ref c_invoice.ref_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoiceline_stimeexpenseline s_timeexpenseline.c_invoiceline_id c_invoiceline.c_invoiceline_id Restrict delete 
convoiceline_ref c_invoiceline.ref_invoiceline_id c_invoiceline.c_invoiceline_id Restrict delete 
corder_cinvoice c_invoice.c_order_id c_order.c_order_id Restrict delete 
corder_corderline c_orderline.c_order_id c_order.c_order_id Restrict delete 
corder_cprojectline c_projectline.c_order_id c_order.c_order_id Restrict delete 
corder_cprojectphase c_projectphase.c_order_id c_order.c_order_id Restrict delete 
corder_minout m_inout.c_order_id c_order.c_order_id Restrict delete 
corder_ref c_order.ref_order_id c_order.c_order_id Restrict delete 
corderline_cinvoiceline c_invoiceline.c_orderline_id c_orderline.c_orderline_id Restrict delete 
corderline_minout m_inoutline.c_orderline_id c_orderline.c_orderline_id Restrict delete 
corderline_ref c_orderline.ref_orderline_id c_orderline.c_orderline_id Restrict delete 
corderline_stimeexpenseline s_timeexpenseline.c_orderline_id c_orderline.c_orderline_id Restrict delete 
corderpo_cprojectline c_projectline.c_orderpo_id c_order.c_order_id Restrict delete 
cpaymentterm_cbpartner c_bpartner.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpaymentterm_cinvoice c_invoice.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpaymentterm_cproject c_project.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpaymentterm_soheader c_order.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cphase_ccyclephase c_cyclephase.c_phase_id c_phase.c_phase_id Cascade on delete 
cphase_cproject c_project.c_phase_id c_phase.c_phase_id Restrict delete 
cphase_cprojectphase c_projectphase.c_phase_id c_phase.c_phase_id Restrict delete 
cphase_ctask c_task.c_phase_id c_phase.c_phase_id Cascade on delete 
cpopaymentterm_cbpartner c_bpartner.po_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cproject_aasset a_asset.c_project_id c_project.c_project_id Restrict delete 
cproject_cinvoice c_invoice.c_project_id c_project.c_project_id Restrict delete 
cproject_cinvoiceline c_invoiceline.c_project_id c_project.c_project_id Restrict delete 
cproject_corder c_order.c_project_id c_project.c_project_id Restrict delete 
cproject_corderline c_orderline.c_project_id c_project.c_project_id Restrict delete 
cproject_cprojectissue c_projectissue.c_project_id c_project.c_project_id Restrict delete 
cproject_cprojectline c_projectline.c_project_id c_project.c_project_id Cascade on delete 
cproject_cprojectphase c_projectphase.c_project_id c_project.c_project_id Restrict delete 
cproject_minout m_inout.c_project_id c_project.c_project_id Restrict delete 
cproject_minoutline m_inoutline.c_project_id c_project.c_project_id Restrict delete 
cproject_stimeexpenseline s_timeexpenseline.c_project_id c_project.c_project_id Restrict delete 
cprojectissue_cprojectline c_projectline.c_projectissue_id c_projectissue.c_projectissue_id Restrict delete 
cprojectissue_mtransaction m_transaction.c_projectissue_id c_projectissue.c_projectissue_id Restrict delete 
cprojectphase_cinvoiceline c_invoiceline.c_projectphase_id c_projectphase.c_projectphase_id Null on delete 
cprojectphase_corderline c_orderline.c_projectphase_id c_projectphase.c_projectphase_id Null on delete 
cprojectphase_cprojectline c_projectline.c_projectphase_id c_projectphase.c_projectphase_id Null on delete 
cprojectphase_cprojecttask c_projecttask.c_projectphase_id c_projectphase.c_projectphase_id Cascade on delete 
cprojectphase_stimeexpenseline s_timeexpenseline.c_projectphase_id c_projectphase.c_projectphase_id Restrict delete 
cprojecttask_cinvoiceline c_invoiceline.c_projecttask_id c_projecttask.c_projecttask_id Null on delete 
cprojecttask_corderline c_orderline.c_projecttask_id c_projecttask.c_projecttask_id Null on delete 
cprojecttask_cprojectline c_projectline.c_projecttask_id c_projecttask.c_projecttask_id Null on delete 
cprojecttask_minoutline m_inoutline.c_projecttask_id c_projecttask.c_projecttask_id Restrict delete 
cprojecttask_stimeexpenseline s_timeexpenseline.c_projecttask_id c_projecttask.c_projecttask_id Restrict delete 
cprojecttype_cphase c_phase.c_projecttype_id c_projecttype.c_projecttype_id Cascade on delete 
cprojecttype_cproject c_project.c_projecttype_id c_projecttype.c_projecttype_id Restrict delete 
ctask_cprojecttask c_projecttask.c_task_id c_task.c_task_id Restrict delete 
dropshipbpartner_corder c_order.dropship_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
dropshipbpartner_minout m_inout.dropship_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
leasebpartner_aasset a_asset.lease_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
linkorder_corder c_order.link_order_id c_order.c_order_id Null on delete 
linkorderline_corderline c_orderline.link_orderline_id c_orderline.c_orderline_id Null on delete 
minout_minoutline m_inoutline.m_inout_id m_inout.m_inout_id Cascade on delete 
minout_ref m_inout.ref_inout_id m_inout.m_inout_id Restrict delete 
minoutline_aasset a_asset.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_cinvoiceline c_invoiceline.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_cprojectissue c_projectissue.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_mtransaction m_transaction.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_ref m_inoutline.ref_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
mpricelistversion_cproject c_project.m_pricelist_version_id m_pricelist_version.m_pricelist_version_id Restrict delete 
mpricelistversionbase_mpriceli m_pricelist_version.m_pricelist_version_base_id m_pricelist_version.m_pricelist_version_id Restrict delete 
mproduct_aasset a_asset.m_product_id m_product.m_product_id Restrict delete 
mproduct_cinvoiceline c_invoiceline.m_product_id m_product.m_product_id Restrict delete 
mproduct_corderline c_orderline.m_product_id m_product.m_product_id Restrict delete 
mproduct_cphase c_phase.m_product_id m_product.m_product_id Restrict delete 
mproduct_cprojectissue c_projectissue.m_product_id m_product.m_product_id Restrict delete 
mproduct_cprojectline c_projectline.m_product_id m_product.m_product_id Restrict delete 
mproduct_cprojectphase c_projectphase.m_product_id m_product.m_product_id Restrict delete 
mproduct_cprojecttask c_projecttask.m_product_id m_product.m_product_id Restrict delete 
mproduct_ctask c_task.m_product_id m_product.m_product_id Restrict delete 
mproduct_minoutline m_inoutline.m_product_id m_product.m_product_id Restrict delete 
mproduct_minventorycount m_transaction.m_product_id m_product.m_product_id Restrict delete 
mproduct_stimeexpenseline s_timeexpenseline.m_product_id m_product.m_product_id Restrict delete 
mwarehouse_corder c_order.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_corderline c_orderline.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_cproject c_project.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_minout m_inout.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_sresource s_resource.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehousesource_mwarehouse m_warehouse.m_warehousesource_id m_warehouse.m_warehouse_id Restrict delete 
quotationorder_corder c_order.quotationorder_id c_order.c_order_id Restrict delete 
relatedinvoice_cinvoice c_invoice.relatedinvoice_id c_invoice.c_invoice_id Restrict delete 
returnbpartner_minout m_inout.returnbpartner_id c_bpartner.c_bpartner_id Restrict delete 
reversal_cinvoice c_invoice.reversal_id c_invoice.c_invoice_id Restrict delete 
reversal_cprojectissue c_projectissue.reversal_id c_projectissue.c_projectissue_id Restrict delete 
reversal_minout m_inout.reversal_id m_inout.m_inout_id Restrict delete 
reversalline_minoutline m_inoutline.reversalline_id m_inoutline.m_inoutline_id Restrict delete 
sresource_mproduct m_product.s_resource_id s_resource.s_resource_id Restrict delete 
stimeexpline_cprojectissue c_projectissue.s_timeexpenseline_id s_timeexpenseline.s_timeexpenseline_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected