SchemaSpy Analysis of idempiere11.adempiere - ConstraintsOrder Management Generated by
Quality Systems & Solutions
138 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
aduser1_cordersource c_ordersource.createdby ad_user.ad_user_id Restrict delete 
aduser2_cordersource c_ordersource.updatedby ad_user.ad_user_id Restrict delete 
aduser_corder c_order.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_cproject c_project.ad_user_id ad_user.ad_user_id Null on delete 
aduser_mshippingtransaction m_shippingtransaction.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_sr_corder c_order.salesrep_id ad_user.ad_user_id Restrict delete 
aduser_sr_cproject c_project.salesrep_id ad_user.ad_user_id Restrict delete 
aduser_supervisor ad_user.supervisor_id ad_user.ad_user_id Restrict delete 
aduserbill_corder c_order.bill_user_id ad_user.ad_user_id Restrict delete 
adusersalesrep_cbpartner c_bpartner.salesrep_id ad_user.ad_user_id Null on delete 
basepricelist m_pricelist.basepricelist_id m_pricelist.m_pricelist_id Restrict delete 
billlocation_mshippingtransact m_shippingtransaction.bill_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
c_order__c_orders_c_ordersou c_order.c_ordersource_id c_ordersource.c_ordersource_id Restrict delete 
cbpartner_aduser ad_user.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_cbplocation c_bpartner_location.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_cbpshippingacct c_bp_shippingacct.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_ccharge c_charge.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_cpayment c_payment.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_mdistlistline m_distributionlistline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_mdistributionrun m_distributionrun.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_mproductpricevendorb m_productpricevendorbreak.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_mshipper m_shipper.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_mshippingtransaction m_shippingtransaction.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_tdrdetail t_distributionrundetail.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartnerbill_corder c_order.bill_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnerloc_mdistlistline m_distributionlistline.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbpartnerlocation_cbpshippinga c_bp_shippingacct.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbpartnerlocation_corder c_order.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbpartnerlocation_mshippingtra m_shippingtransaction.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbpartnerlocation_soline c_orderline.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbpartnerlocation_tdrdetail t_distributionrundetail.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Cascade on delete 
cbpartnerpay_corder c_order.pay_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnersr_cproject c_project.c_bpartnersr_id c_bpartner.c_bpartner_id Restrict delete 
cbplocation_aduser ad_user.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbplocation_cproject c_project.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbplocation_mdistributionrun m_distributionrun.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbplocationbill_corder c_order.bill_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbplocationpay_corder c_order.pay_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbpshippingacct_mshippingtrans m_shippingtransaction.c_bp_shippingacct_id c_bp_shippingacct.c_bp_shippingacct_id Restrict delete 
ccharge_corder c_order.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_corderline c_orderline.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_cpayment c_payment.c_charge_id c_charge.c_charge_id Restrict delete 
corder_corderline c_orderline.c_order_id c_order.c_order_id Restrict delete 
corder_corderpayschedule c_orderpayschedule.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_cpayment c_payment.c_order_id c_order.c_order_id Restrict delete 
corder_cpospayment c_pospayment.c_order_id c_order.c_order_id Restrict delete 
corder_mshippingtransaction m_shippingtransaction.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_ref c_orderline.ref_orderline_id c_orderline.c_orderline_id Restrict delete 
cpayment_corder c_order.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_cpospayment c_pospayment.c_payment_id c_payment.c_payment_id Restrict delete 
cpaymentterm_cbpartner c_bpartner.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 
cpopaymentterm_cbpartner c_bpartner.po_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpostendertype_cpayment c_payment.c_postendertype_id c_postendertype.c_postendertype_id Restrict delete 
cpostendertype_cpospayment c_pospayment.c_postendertype_id c_postendertype.c_postendertype_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_cpayment c_payment.c_project_id c_project.c_project_id Restrict delete 
crevrecognition_mproduct m_product.c_revenuerecognition_id c_revenuerecognition.c_revenuerecognition_id Restrict delete 
cservicelevel_line c_servicelevelline.c_servicelevel_id c_servicelevel.c_servicelevel_id Cascade on delete 
ctax_corderline c_orderline.c_tax_id c_tax.c_tax_id Restrict delete 
ctax_cordertax c_ordertax.c_tax_id c_tax.c_tax_id Restrict delete 
ctax_mrmatax m_rmatax.c_tax_id c_tax.c_tax_id Restrict delete 
ctax_parent c_tax.parent_tax_id c_tax.c_tax_id Restrict delete 
ctaxcategory_ccharge c_charge.c_taxcategory_id c_taxcategory.c_taxcategory_id Restrict delete 
ctaxcategory_ctax c_tax.c_taxcategory_id c_taxcategory.c_taxcategory_id Cascade on delete 
ctaxcategory_mproduct m_product.c_taxcategory_id c_taxcategory.c_taxcategory_id Restrict delete 
dropshipbpartner_corder c_order.dropship_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
dropshiplocation_corder c_order.dropship_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
dropshipuser_corder c_order.dropship_user_id ad_user.ad_user_id Restrict delete 
holdaddress_mshippingtransacti m_shippingtransaction.holdaddress_id c_bpartner_location.c_bpartner_location_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 
mdistributionlist_line m_distributionlistline.m_distributionlist_id m_distributionlist.m_distributionlist_id Cascade on delete 
mdistributionlist_runline m_distributionrunline.m_distributionlist_id m_distributionlist.m_distributionlist_id Cascade on delete 
mdistributionlist_tdrdetail t_distributionrundetail.m_distributionlist_id m_distributionlist.m_distributionlist_id Cascade on delete 
mdistributionlline_tdrdetail t_distributionrundetail.m_distributionlistline_id m_distributionlistline.m_distributionlistline_id Cascade on delete 
mdistributionrline_tdrdetail t_distributionrundetail.m_distributionrunline_id m_distributionrunline.m_distributionrunline_id Cascade on delete 
mdistributionrun_line m_distributionrunline.m_distributionrun_id m_distributionrun.m_distributionrun_id Cascade on delete 
mdistributionrun_tdrdetail t_distributionrundetail.m_distributionrun_id m_distributionrun.m_distributionrun_id Cascade on delete 
mpricelist_cbpartner c_bpartner.m_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mpricelist_mpricelistversion m_pricelist_version.m_pricelist_id m_pricelist.m_pricelist_id Cascade on delete 
mpricelist_soheader c_order.m_pricelist_id m_pricelist.m_pricelist_id Restrict delete 
mpricelistpo_cbuspartner c_bpartner.po_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mpricelistver_mproductprice m_productprice.m_pricelist_version_id m_pricelist_version.m_pricelist_version_id Cascade on delete 
mpricelistversion_cproject c_project.m_pricelist_version_id m_pricelist_version.m_pricelist_version_id Restrict delete 
mpricelistversion_mproductpric m_productpricevendorbreak.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_corderline c_orderline.m_product_id m_product.m_product_id Restrict delete 
mproduct_cservicelevel c_servicelevel.m_product_id m_product.m_product_id Restrict delete 
mproduct_mcommodityshipment m_commodityshipment.m_product_id m_product.m_product_id Restrict delete 
mproduct_mdistributionrun m_distributionrunline.m_product_id m_product.m_product_id Restrict delete 
mproduct_mproductprice m_productprice.m_product_id m_product.m_product_id Cascade on delete 
mproduct_mproductpricevendorbr m_productpricevendorbreak.m_product_id m_product.m_product_id Restrict delete 
mproduct_tdrdetail t_distributionrundetail.m_product_id m_product.m_product_id Cascade on delete 
mshipper_corder c_order.m_shipper_id m_shipper.m_shipper_id Restrict delete 
mshipper_corderline c_orderline.m_shipper_id m_shipper.m_shipper_id Restrict delete 
mshipper_mshipperlabels m_shipperlabels.m_shipper_id m_shipper.m_shipper_id Restrict delete 
mshipper_mshipperpackaging m_shipperpackaging.m_shipper_id m_shipper.m_shipper_id Restrict delete 
mshipper_mshipperpickuptypes m_shipperpickuptypes.m_shipper_id m_shipper.m_shipper_id Restrict delete 
mshipper_mshippingtransaction m_shippingtransaction.m_shipper_id m_shipper.m_shipper_id Restrict delete 
mshippercfg_mshipper m_shipper.m_shippercfg_id m_shippercfg.m_shippercfg_id Restrict delete 
mshippercfg_mshipperlabelscfg m_shipperlabelscfg.m_shippercfg_id m_shippercfg.m_shippercfg_id Restrict delete 
mshippercfg_mshipperpackagingc m_shipperpackagingcfg.m_shippercfg_id m_shippercfg.m_shippercfg_id Restrict delete 
mshippercfg_mshipperpickuptype m_shipperpickuptypescfg.m_shippercfg_id m_shippercfg.m_shippercfg_id Restrict delete 
mshipperlabels_mshippingtransa m_shippingtransaction.m_shipperlabels_id m_shipperlabels.m_shipperlabels_id Restrict delete 
mshipperlabelscfg_mshipperlabe m_shipperlabels.m_shipperlabelscfg_id m_shipperlabelscfg.m_shipperlabelscfg_id Restrict delete 
mshipperpackaging_mshippingtra m_shippingtransaction.m_shipperpackaging_id m_shipperpackaging.m_shipperpackaging_id Restrict delete 
mshipperpackagingcfg_mshipperp m_shipperpackaging.m_shipperpackagingcfg_id m_shipperpackagingcfg.m_shipperpackagingcfg_id Restrict delete 
mshipperpickuptypes_mshippingt m_shippingtransaction.m_shipperpickuptypes_id m_shipperpickuptypes.m_shipperpickuptypes_id Restrict delete 
mshipperpickuptypescfg_mshippe m_shipperpickuptypes.m_shipperpickuptypescfg_id m_shipperpickuptypescfg.m_shipperpickuptypescfg_id Restrict delete 
mshippingprocessor_cbpshipping c_bp_shippingacct.m_shippingprocessor_id m_shippingprocessor.m_shippingprocessor_id Restrict delete 
mshippingprocessor_mshipper m_shipper.m_shippingprocessor_id m_shippingprocessor.m_shippingprocessor_id Restrict delete 
mshippingprocessor_mshippingtr m_shippingtransaction.m_shippingprocessor_id m_shippingprocessor.m_shippingprocessor_id Restrict delete 
mshippingprocessorcfg_mshipper m_shippercfg.m_shippingprocessorcfg_id m_shippingprocessorcfg.m_shippingprocessorcfg_id Restrict delete 
mshippingprocessorcfg_mshippin m_shippingprocessor.m_shippingprocessorcfg_id m_shippingprocessorcfg.m_shippingprocessorcfg_id Restrict delete 
mshippingtransaction_mshipping m_shippingtransactionline.m_shippingtransaction_id m_shippingtransaction.m_shippingtransaction_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_mshippingtransactio m_shippingtransaction.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 
refpayment_cpayment c_payment.ref_payment_id c_payment.c_payment_id Restrict delete 
returnbpartner_mshippingtransa m_shippingtransaction.returnbpartner_id c_bpartner.c_bpartner_id Restrict delete 
returnlocation_mshippingtransa m_shippingtransaction.returnlocation_id c_bpartner_location.c_bpartner_location_id Restrict delete 
returnuser_mshippingtransactio m_shippingtransaction.returnuser_id ad_user.ad_user_id Restrict delete 
reversal_cpayment c_payment.reversal_id c_payment.c_payment_id Restrict delete 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 
salesrep_mproduct m_product.salesrep_id ad_user.ad_user_id Restrict delete 
salesrep_mshippingtransaction m_shippingtransaction.salesrep_id ad_user.ad_user_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected