SchemaSpy Analysis of idempiere9.adempiere - ConstraintsMaterial Confirmations Generated by
Quality Systems & Solutions
30 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
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_minoutconfirm m_inoutconfirm.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_minoutlineconfirm m_inoutlineconfirm.c_invoiceline_id c_invoiceline.c_invoiceline_id Restrict delete 
convoiceline_ref c_invoiceline.ref_invoiceline_id c_invoiceline.c_invoiceline_id Restrict delete 
minout_minoutconfirm m_inoutconfirm.m_inout_id m_inout.m_inout_id Cascade 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 
minoutconfirm_minoutlineconf m_inoutlineconfirm.m_inoutconfirm_id m_inoutconfirm.m_inoutconfirm_id Cascade on delete 
minoutline_cinvoiceline c_invoiceline.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_minoutconfirm m_inoutlineconfirm.m_inoutline_id m_inoutline.m_inoutline_id Cascade on delete 
minoutline_ref m_inoutline.ref_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minventory_minoutconfirm m_inoutconfirm.m_inventory_id m_inventory.m_inventory_id Restrict delete 
minventory_minventoryline m_inventoryline.m_inventory_id m_inventory.m_inventory_id Cascade on delete 
minventory_mmovconfirm m_movementconfirm.m_inventory_id m_inventory.m_inventory_id Restrict delete 
minventoryline_minoutlineconfi m_inoutlineconfirm.m_inventoryline_id m_inventoryline.m_inventoryline_id Restrict delete 
minventoryline_mmovlineconfirm m_movementlineconfirm.m_inventoryline_id m_inventoryline.m_inventoryline_id Restrict delete 
mmovement_mmovementconfirm m_movementconfirm.m_movement_id m_movement.m_movement_id Cascade on delete 
mmovement_mmovementline m_movementline.m_movement_id m_movement.m_movement_id Cascade on delete 
mmovementconfirm_mmovlineconf m_movementlineconfirm.m_movementconfirm_id m_movementconfirm.m_movementconfirm_id Cascade on delete 
mmovementline_mmovlineconfirm m_movementlineconfirm.m_movementline_id m_movementline.m_movementline_id Cascade on 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_mmovement m_movement.reversal_id m_movement.m_movement_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 
reversalline_mmovementline m_movementline.reversalline_id m_movementline.m_movementline_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected