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

Constraint Name Child Column Parent Column Delete Rule
basepricelist m_pricelist.basepricelist_id m_pricelist.m_pricelist_id Restrict delete 
c_uom_m_product_po m_product_po.c_uom_id c_uom.c_uom_id Restrict delete 
c_uomconversionto c_uom_conversion.c_uom_to_id c_uom.c_uom_id Restrict delete 
ccharge_minout m_inout.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_minoutline m_inoutline.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_minventoryline m_inventoryline.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_mmovement m_movement.c_charge_id c_charge.c_charge_id Restrict delete 
cdoctype_invoice c_doctype.c_doctypeinvoice_id c_doctype.c_doctype_id Restrict delete 
cdoctype_minout m_inout.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_minventory m_inventory.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_mmovement m_movement.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_mproduction m_production.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_mstoragereservationlo m_storagereservationlog.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_proforma c_doctype.c_doctypeproforma_id c_doctype.c_doctype_id Restrict delete 
cdoctype_shipment c_doctype.c_doctypeshipment_id c_doctype.c_doctype_id Restrict delete 
cdoctype_treplenish t_replenish.c_doctype_id c_doctype.c_doctype_id Cascade on delete 
cdoctypedifference_cdoctype c_doctype.c_doctypedifference_id c_doctype.c_doctype_id Restrict delete 
cprojectissue_cprojectissuema c_projectissuema.c_projectissue_id c_projectissue.c_projectissue_id Restrict delete 
cprojectissue_mtransaction m_transaction.c_projectissue_id c_projectissue.c_projectissue_id Restrict delete 
cprojectissue_ttransaction t_transaction.c_projectissue_id c_projectissue.c_projectissue_id Cascade on delete 
cuom_cuomconversion c_uom_conversion.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_minoutline m_inoutline.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_mproduct m_product.c_uom_id c_uom.c_uom_id Restrict delete 
m_product_productpo m_product_po.m_product_id m_product.m_product_id Cascade on delete 
m_product_replenish m_replenish.m_product_id m_product.m_product_id Cascade on delete 
m_warehouse_locator m_locator.m_warehouse_id m_warehouse.m_warehouse_id Cascade on delete 
m_warehouse_replenish m_replenish.m_warehouse_id m_warehouse.m_warehouse_id Cascade on delete 
masi_cprojectissuema c_projectissuema.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
masi_minourlinema m_inoutlinema.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Cascade on delete 
masi_minventorylinema m_inventorylinema.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Cascade on delete 
masi_mmovementlinema m_movementlinema.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Cascade on delete 
masi_mproductionlinema m_productionlinema.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Cascade on delete 
masi_ttransaction t_transaction.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Cascade on delete 
mattributesetinst_mtrxalloc m_transactionallocation.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattributesetinstance_mquality m_qualitytestresult.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattributesetinstance_mstorage m_storagereservationlog.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattributesetinstance_mstoraoh m_storageonhand.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattributesetinstance_mstorare m_storagereservation.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattributesetinstanceto_mmovem m_movementline.m_attributesetinstanceto_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattrsetinst_cprojectissue c_projectissue.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattrsetinst_minoutline m_inoutline.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattrsetinst_minventoryline m_inventoryline.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattrsetinst_mmovementline m_movementline.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattrsetinst_mproduct m_product.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattrsetinst_mproductionline m_productionline.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattrsetinst_mtransaction m_transaction.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_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_cprojectissue c_projectissue.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_minoutlinema m_inoutlinema.m_inoutline_id m_inoutline.m_inoutline_id Cascade on delete 
minoutline_mproduction m_production.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_mtransaction m_transaction.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_mtrxalloc m_transactionallocation.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_ref m_inoutline.ref_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_ttransaction t_transaction.m_inoutline_id m_inoutline.m_inoutline_id Cascade on delete 
minoutlineout_mtrxalloc m_transactionallocation.out_m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minventory_minventoryline m_inventoryline.m_inventory_id m_inventory.m_inventory_id Cascade on delete 
minventoryline_milinema m_inventorylinema.m_inventoryline_id m_inventoryline.m_inventoryline_id Cascade on delete 
minventoryline_mtransaction m_transaction.m_inventoryline_id m_inventoryline.m_inventoryline_id Restrict delete 
minventoryline_mtrxalloc m_transactionallocation.m_inventoryline_id m_inventoryline.m_inventoryline_id Restrict delete 
minventoryline_ttransaction t_transaction.m_inventoryline_id m_inventoryline.m_inventoryline_id Cascade on delete 
minventorylineout_mtrxalloc m_transactionallocation.out_m_inventoryline_id m_inventoryline.m_inventoryline_id Restrict delete 
mlocator_cprojectissue c_projectissue.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_minoutline m_inoutline.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_minventorycount m_transaction.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_minventoryline m_inventoryline.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_movementline m_movementline.m_locatorto_id m_locator.m_locator_id Restrict delete 
mlocator_mproduct m_product.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_mproduction m_production.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_mproductionline m_productionline.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_mproductionplan m_productionplan.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_mreplenish m_replenish.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_mstorageonhand m_storageonhand.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_ttransaction t_transaction.m_locator_id m_locator.m_locator_id Cascade on delete 
mlocatorto_mmovementline m_movementline.m_locator_id m_locator.m_locator_id Restrict delete 
mlocatortype_mlocator m_locator.m_locatortype_id m_locatortype.m_locatortype_id Restrict delete 
mmovement_mmovementline m_movementline.m_movement_id m_movement.m_movement_id Cascade on delete 
mmovementline_mmovementlinema m_movementlinema.m_movementline_id m_movementline.m_movementline_id Cascade on delete 
mmovementline_mtransaction m_transaction.m_movementline_id m_movementline.m_movementline_id Restrict delete 
mmovementline_ttransaction t_transaction.m_movementline_id m_movementline.m_movementline_id Cascade on delete 
mparttype_mproduct m_product.m_parttype_id m_parttype.m_parttype_id Restrict delete 
mperpetualinv_minventory m_inventory.m_perpetualinv_id m_perpetualinv.m_perpetualinv_id Restrict delete 
mpricelist_mpricelistversion m_pricelist_version.m_pricelist_id m_pricelist.m_pricelist_id Cascade on delete 
mpricelistver_mproductprice m_productprice.m_pricelist_version_id m_pricelist_version.m_pricelist_version_id Cascade on 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 
mprodcategory_mperpetualinv m_perpetualinv.m_product_category_id m_product_category.m_product_category_id Restrict delete 
mproduct_cprojectissue c_projectissue.m_product_id m_product.m_product_id Restrict delete 
mproduct_cuomconversion c_uom_conversion.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_minventorycount m_transaction.m_product_id m_product.m_product_id Restrict delete 
mproduct_minventoryline m_inventoryline.m_product_id m_product.m_product_id Restrict delete 
mproduct_mmovementline m_movementline.m_product_id m_product.m_product_id Restrict delete 
mproduct_mproductcategory m_product.m_product_category_id m_product_category.m_product_category_id Restrict delete 
mproduct_mproduction m_production.m_product_id m_product.m_product_id Restrict delete 
mproduct_mproductionline m_productionline.m_product_id m_product.m_product_id Restrict delete 
mproduct_mproductionplan m_productionplan.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_mproductqualitytest m_product_qualitytest.m_product_id m_product.m_product_id Restrict delete 
mproduct_mstorageonhand m_storageonhand.m_product_id m_product.m_product_id Restrict delete 
mproduct_mstoragereservation m_storagereservation.m_product_id m_product.m_product_id Restrict delete 
mproduct_mstoragereservationlo m_storagereservationlog.m_product_id m_product.m_product_id Restrict delete 
mproduct_mtrxalloc m_transactionallocation.m_product_id m_product.m_product_id Restrict delete 
mproduct_qmspecification qm_specification.m_product_id m_product.m_product_id Restrict delete 
mproduct_substitute m_substitute.m_product_id m_product.m_product_id Cascade on delete 
mproduct_substitutesub m_substitute.substitute_id m_product.m_product_id Cascade on delete 
mproduct_treplenish t_replenish.m_product_id m_product.m_product_id Cascade on delete 
mproduct_ttransaction t_transaction.m_product_id m_product.m_product_id Cascade on delete 
mproductcat_parentcat m_product_category.m_product_category_parent_id m_product_category.m_product_category_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 
mproductionline_mplinema m_productionlinema.m_productionline_id m_productionline.m_productionline_id Cascade on delete 
mproductionline_mtransaction m_transaction.m_productionline_id m_productionline.m_productionline_id Restrict delete 
mproductionline_mtrxalloc m_transactionallocation.m_productionline_id m_productionline.m_productionline_id Restrict delete 
mproductionline_ttransaction t_transaction.m_productionline_id m_productionline.m_productionline_id Cascade on delete 
mproductionlineout_mtrxalloc m_transactionallocation.out_m_productionline_id m_productionline.m_productionline_id Restrict delete 
mproductionplan_line m_productionline.m_productionplan_id m_productionplan.m_productionplan_id Cascade on delete 
mqualitytest_mproductqualityte m_product_qualitytest.m_qualitytest_id m_qualitytest.m_qualitytest_id Restrict delete 
mqualitytest_mqualitytestresul m_qualitytestresult.m_qualitytest_id m_qualitytest.m_qualitytest_id Restrict delete 
mreservelocator_mwarehouse m_warehouse.m_reservelocator_id m_locator.m_locator_id Restrict delete 
mshipper_minout m_inout.m_shipper_id m_shipper.m_shipper_id Restrict delete 
mshipper_mmovement m_movement.m_shipper_id m_shipper.m_shipper_id Restrict delete 
mtransaction_ttransaction t_transaction.m_transaction_id m_transaction.m_transaction_id Cascade on delete 
mtransactionout_mtrxalloc m_transactionallocation.out_m_transaction_id m_transaction.m_transaction_id Restrict delete 
mttransaction_mtrxalloc m_transactionallocation.m_transaction_id m_transaction.m_transaction_id Cascade on delete 
mwarehouse_minout m_inout.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_minventory m_inventory.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_mmovement m_movement.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_mperpetualinv m_perpetualinv.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_mstoragereservation m_storagereservation.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_treplenish t_replenish.m_warehouse_id m_warehouse.m_warehouse_id Cascade on delete 
mwarehousesource_mreplenish m_replenish.m_warehousesource_id m_warehouse.m_warehouse_id Restrict delete 
mwarehousesource_mwarehouse m_warehouse.m_warehousesource_id m_warehouse.m_warehouse_id Restrict delete 
mwarehousesource_treplenish t_replenish.m_warehousesource_id m_warehouse.m_warehouse_id Cascade on delete 
mwarehouseto_mmovement m_movement.m_warehouseto_id m_warehouse.m_warehouse_id Restrict delete 
mwh_mstoragereservationlog m_storagereservationlog.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
qmspecification_qmspecificatio qm_specificationline.qm_specification_id qm_specification.qm_specification_id Restrict delete 
reversal_cprojectissue c_projectissue.reversal_id c_projectissue.c_projectissue_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 
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 
reversalline_mmovementline m_movementline.reversalline_id m_movementline.m_movementline_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected