SchemaSpy Analysis of idempiere11.adempiere - ConstraintsPrinting Documents Generated by
Quality Systems & Solutions
56 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
cdunningrun_cdunningrunentry c_dunningrunentry.c_dunningrun_id c_dunningrun.c_dunningrun_id Cascade on delete 
cdunningrunentry_line c_dunningrunline.c_dunningrunentry_id c_dunningrunentry.c_dunningrunentry_id Cascade on delete 
cinvoice_cdunningrunline c_dunningrunline.c_invoice_id c_invoice.c_invoice_id Null on delete 
cinvoice_cinvoiceline c_invoiceline.c_invoice_id c_invoice.c_invoice_id Cascade on delete 
cinvoice_cinvoicetax c_invoicetax.c_invoice_id c_invoice.c_invoice_id Cascade on delete 
cinvoice_cpayselectline c_payselectionline.c_invoice_id c_invoice.c_invoice_id Restrict 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_cordertax c_ordertax.c_order_id c_order.c_order_id Cascade on delete 
corder_cprojectline c_projectline.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_mproduction m_production.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 
cpaysel_cpayselline c_payselectionline.c_payselection_id c_payselection.c_payselection_id Cascade on delete 
cpayselcheck_cpayselline c_payselectionline.c_payselectioncheck_id c_payselectioncheck.c_payselectioncheck_id Restrict delete 
cpayselection_cpayselectcheck c_payselectioncheck.c_payselection_id c_payselection.c_payselection_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_cprojectline c_projectline.c_project_id c_project.c_project_id Cascade on 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_minventory m_inventory.c_project_id c_project.c_project_id Restrict delete 
cproject_mproduction m_production.c_project_id c_project.c_project_id Restrict delete 
cproject_stimeexpenseline s_timeexpenseline.c_project_id c_project.c_project_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_cinvoiceline c_invoiceline.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_mproduction m_production.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_ref m_inoutline.ref_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minventory_minventoryline m_inventoryline.m_inventory_id m_inventory.m_inventory_id Cascade on delete 
mproduction_cprojectline c_projectline.m_production_id m_production.m_production_id Restrict delete 
mproduction_mproductionline m_productionline.m_production_id m_production.m_production_id Restrict delete 
mproduction_plan m_productionplan.m_production_id m_production.m_production_id Cascade on delete 
mproductionplan_line m_productionline.m_productionplan_id m_productionplan.m_productionplan_id Cascade on 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 
reversal_cinvoice c_invoice.reversal_id c_invoice.c_invoice_id Restrict delete 
reversal_minout m_inout.reversal_id m_inout.m_inout_id Restrict delete 
reversal_minventory m_inventory.reversal_id m_inventory.m_inventory_id Restrict delete 
reversal_mproduction m_production.reversal_id m_production.m_production_id Restrict delete 
reversalline_minoutline m_inoutline.reversalline_id m_inoutline.m_inoutline_id Restrict delete 
reversalline_minventoryline m_inventoryline.reversalline_id m_inventoryline.m_inventoryline_id Restrict delete 
stimeexpense_line s_timeexpenseline.s_timeexpense_id s_timeexpense.s_timeexpense_id Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected