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

Constraint Name Child Column Parent Column Delete Rule
ad_org_mproduct m_product.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_celementvalue c_elementvalue.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_cinvoice c_invoice.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_cinvoiceline c_invoiceline.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_corder c_order.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_corderline c_orderline.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_cproject c_project.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_minoutline m_inoutline.ad_org_id ad_org.ad_org_id Restrict delete 
adorgtrx_cinvoice c_invoice.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_cinvoiceline c_invoiceline.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_corder c_order.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_corderline c_orderline.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_cproject c_project.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_minoutline m_inoutline.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
c_projectphase_minoutline m_inoutline.c_projectphase_id c_projectphase.c_projectphase_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_minoutline m_inoutline.c_activity_id c_activity.c_activity_id Restrict delete 
ccampaign_cinvoice c_invoice.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_cinvoiceline c_invoiceline.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_corder c_order.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_corderline c_orderline.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_cproject c_project.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_minoutline m_inoutline.c_campaign_id c_campaign.c_campaign_id Restrict delete 
celemenrvalueuser1_cinvline c_invoiceline.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celemenrvalueuser1_corderline c_orderline.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celemenrvalueuser1_minoutline m_inoutline.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celemenrvalueuser2_cinvline c_invoiceline.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celemenrvalueuser2_corder c_order.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celemenrvalueuser2_corderline c_orderline.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celemenrvalueuser2_minoutline m_inoutline.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser1_cinvoice c_invoice.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser1_corder c_order.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser2_cinvoice c_invoice.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
cinvoice_cinvoiceline c_invoiceline.c_invoice_id c_invoice.c_invoice_id Cascade on 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_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_cprojectphase c_projectphase.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_mrequisitionline m_requisitionline.c_orderline_id c_orderline.c_orderline_id Restrict delete 
corderline_ref c_orderline.ref_orderline_id c_orderline.c_orderline_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_cprojectphase c_projectphase.c_project_id c_project.c_project_id Restrict delete 
cproject_minoutline m_inoutline.c_project_id c_project.c_project_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_cprojecttask c_projecttask.c_projectphase_id c_projectphase.c_projectphase_id Cascade on 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_minoutline m_inoutline.c_projecttask_id c_projecttask.c_projecttask_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 
m_product_productpo m_product_po.m_product_id m_product.m_product_id Cascade on delete 
m_productpo_org m_product_po.ad_org_id ad_org.ad_org_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 
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_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_minoutline m_inoutline.m_product_id m_product.m_product_id Restrict delete 
mproduct_mmatchinv m_matchinv.m_product_id m_product.m_product_id Restrict delete 
mproduct_mmatchpo m_matchpo.m_product_id m_product.m_product_id Restrict delete 
mproduct_mrequisitionline m_requisitionline.m_product_id m_product.m_product_id Restrict delete 
mrequisition_mrequisitionline m_requisitionline.m_requisition_id m_requisition.m_requisition_id Cascade on 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 
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_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