SchemaSpy Analysis of idempiere9.adempiere - ConstraintsMatching Allocation Generated by
Quality Systems & Solutions
40 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
cinvoice_callocationline c_allocationline.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_cinvoiceline c_invoiceline.c_invoice_id c_invoice.c_invoice_id Cascade on delete 
cinvoice_cpayment c_payment.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_mmatchpo m_matchpo.c_invoiceline_id c_invoiceline.c_invoiceline_id Restrict delete 
convoiceline_mmatchinv m_matchinv.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_callocation c_allocationline.c_order_id c_order.c_order_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_cpayment c_payment.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_mmatchpo m_matchpo.c_orderline_id c_orderline.c_orderline_id Restrict delete 
corderline_ref c_orderline.ref_orderline_id c_orderline.c_orderline_id Restrict delete 
cpayment_callocationline c_allocationline.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_cinvoice c_invoice.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_corder c_order.c_payment_id c_payment.c_payment_id Restrict delete 
linkorder_corder c_order.link_order_id c_order.c_order_id Restrict delete 
linkorderline_corderline c_orderline.link_orderline_id c_orderline.c_orderline_id Restrict 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_mmatchinv m_matchinv.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_mmatchpo m_matchpo.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_ref m_inoutline.ref_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
quotationorder_corder c_order.quotationorder_id c_order.c_order_id Restrict delete 
refmatchinv_mmatchinv m_matchinv.ref_matchinv_id m_matchinv.m_matchinv_id Restrict delete 
refmatchpo_mmatchpo m_matchpo.ref_matchpo_id m_matchpo.m_matchpo_id Restrict delete 
refpayment_cpayment c_payment.ref_payment_id c_payment.c_payment_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_cpayment c_payment.reversal_id c_payment.c_payment_id Restrict delete 
reversal_minout m_inout.reversal_id m_inout.m_inout_id Restrict delete 
reversal_mmatchinv m_matchinv.reversal_id m_matchinv.m_matchinv_id Restrict delete 
reversal_mmatchpo m_matchpo.reversal_id m_matchpo.m_matchpo_id Restrict delete 
reversalline_minoutline m_inoutline.reversalline_id m_inoutline.m_inoutline_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected