SchemaSpy Analysis of idempiere11.adempiere - ConstraintsProduct Attribute Generated by
Quality Systems & Solutions
83 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
aasset_cinvoiceline c_invoiceline.a_asset_id a_asset.a_asset_id Restrict delete 
adtable_mattributesetexclude m_attributesetexclude.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_mlotctlexclude m_lotctlexclude.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_msernoctlexclude m_sernoctlexclude.ad_table_id ad_table.ad_table_id Restrict delete 
aparentasset_aasset a_asset.a_parent_asset_id a_asset.a_asset_id Restrict delete 
cbpartner_aasset a_asset.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cbpproduct c_bpartner_product.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_soline c_orderline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnersr_aasset a_asset.c_bpartnersr_id c_bpartner.c_bpartner_id Restrict delete 
convoiceline_ref c_invoiceline.ref_invoiceline_id c_invoiceline.c_invoiceline_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_ref c_orderline.ref_orderline_id c_orderline.c_orderline_id Restrict delete 
cprojectissue_mtransaction m_transaction.c_projectissue_id c_projectissue.c_projectissue_id Restrict delete 
leasebpartner_aasset a_asset.lease_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
linkorderline_corderline c_orderline.link_orderline_id c_orderline.c_orderline_id Null on delete 
masetinstance_crfqline c_rfqline.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattribute_mattributeinst m_attributeinstance.m_attribute_id m_attribute.m_attribute_id Restrict delete 
mattribute_mattributeuse m_attributeuse.m_attribute_id m_attribute.m_attribute_id Restrict delete 
mattribute_mattributevalue m_attributevalue.m_attribute_id m_attribute.m_attribute_id Cascade on delete 
mattributesearch_mattribute m_attribute.m_attributesearch_id m_attributesearch.m_attributesearch_id Restrict delete 
mattributeset_masexclude m_attributesetexclude.m_attributeset_id m_attributeset.m_attributeset_id Restrict delete 
mattributeset_mattribsetinst m_attributesetinstance.m_attributeset_id m_attributeset.m_attributeset_id Restrict delete 
mattributeset_mattributeuse m_attributeuse.m_attributeset_id m_attributeset.m_attributeset_id Restrict delete 
mattributeset_mproduct m_product.m_attributeset_id m_attributeset.m_attributeset_id Cascade on delete 
mattributesetinst_mtrxalloc m_transactionallocation.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattributesetinstance_aasset a_asset.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 
mattributevalue_mattrinst m_attributeinstance.m_attributevalue_id m_attributevalue.m_attributevalue_id Restrict delete 
mattrsetinst__mattrinst m_attributeinstance.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Cascade on delete 
mattrsetinst_cinvoiceline c_invoiceline.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattrsetinst_corderline c_orderline.m_attributesetinstance_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 
minoutline_aasset a_asset.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_cinvoiceline c_invoiceline.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_cprojectissue c_projectissue.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 
minoutlineout_mtrxalloc m_transactionallocation.out_m_inoutline_id m_inoutline.m_inoutline_id Restrict 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 
minventorylineout_mtrxalloc m_transactionallocation.out_m_inventoryline_id m_inventoryline.m_inventoryline_id Restrict delete 
mlot_mattributesetinstance m_attributesetinstance.m_lot_id m_lot.m_lot_id Restrict delete 
mlotctl_mattributeset m_attributeset.m_lotctl_id m_lotctl.m_lotctl_id Restrict delete 
mlotctl_mlot m_lot.m_lotctl_id m_lotctl.m_lotctl_id Restrict delete 
mlotctl_mlotctlexclude m_lotctlexclude.m_lotctl_id m_lotctl.m_lotctl_id Restrict delete 
mmovementline_mtransaction m_transaction.m_movementline_id m_movementline.m_movementline_id Restrict delete 
mproduct_aasset a_asset.m_product_id m_product.m_product_id Restrict delete 
mproduct_cbpproduct c_bpartner_product.m_product_id m_product.m_product_id Cascade on 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_cprojectissue c_projectissue.m_product_id m_product.m_product_id Restrict delete 
mproduct_crfqline c_rfqline.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_mlot m_lot.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_mproductionline m_productionline.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_mtrxalloc m_transactionallocation.m_product_id m_product.m_product_id Restrict 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 
mproductionlineout_mtrxalloc m_transactionallocation.out_m_productionline_id m_productionline.m_productionline_id Restrict delete 
msernoctl_attributeset m_attributeset.m_sernoctl_id m_sernoctl.m_sernoctl_id Restrict delete 
msernoctl_msernoctlexclude m_sernoctlexclude.m_sernoctl_id m_sernoctl.m_sernoctl_id Restrict 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 
reversal_cprojectissue c_projectissue.reversal_id c_projectissue.c_projectissue_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