SchemaSpy Analysis of idempiere9.adempiere - ConstraintsRfQ Generated by
Quality Systems & Solutions
69 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
adprintformat_arfqtopic c_rfq_topic.ad_printformat_id ad_printformat.ad_printformat_id Null on delete 
adprintformatinv_cbpartner c_bpartner.invoice_printformat_id ad_printformat.ad_printformat_id Restrict delete 
aduser_arfqtopicsubcr c_rfq_topicsubscriber.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_corder c_order.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_crfq c_rfq.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_crfqresponse c_rfqresponse.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_rcontactinterest r_contactinterest.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_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 
adusersalesrep_crfq c_rfq.salesrep_id ad_user.ad_user_id Restrict delete 
basepricelist m_pricelist.basepricelist_id m_pricelist.m_pricelist_id Restrict delete 
c_rfqtopic_subscriber c_rfq_topicsubscriber.c_rfq_topic_id c_rfq_topic.c_rfq_topic_id Cascade on 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_cbpproduct c_bpartner_product.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_corder c_order.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_crfq c_rfq.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_crfqresponse c_rfqresponse.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_crfqtopicsubr c_rfq_topicsubscriber.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnerbill_corder c_order.bill_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnerloc_crfqtopicsubr c_rfq_topicsubscriber.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 
cbpartnerpay_corder c_order.pay_bpartner_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_crfq c_rfq.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbplocation_crfqresponse c_rfqresponse.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 
ccurrency_corder c_order.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_crfq c_rfq.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_crfqresponse c_rfqresponse.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_mpricelist m_pricelist.c_currency_id c_currency.c_currency_id Restrict delete 
corder_crfq c_rfq.c_order_id c_order.c_order_id Restrict delete 
corder_crfqresponse c_rfqresponse.c_order_id c_order.c_order_id Restrict delete 
corder_ref c_order.ref_order_id c_order.c_order_id Restrict delete 
crfq_crfqline c_rfqline.c_rfq_id c_rfq.c_rfq_id Cascade on delete 
crfq_crfqresponse c_rfqresponse.c_rfq_id c_rfq.c_rfq_id Cascade on delete 
crfqline_crfqlineqty c_rfqlineqty.c_rfqline_id c_rfqline.c_rfqline_id Cascade on delete 
crfqline_crfqresponseline c_rfqresponseline.c_rfqline_id c_rfqline.c_rfqline_id Cascade on delete 
crfqlineqty_crfqresplineqty c_rfqresponselineqty.c_rfqlineqty_id c_rfqlineqty.c_rfqlineqty_id Cascade on delete 
crfqresonseline_qty c_rfqresponselineqty.c_rfqresponseline_id c_rfqresponseline.c_rfqresponseline_id Cascade on delete 
crfqresponse_line c_rfqresponseline.c_rfqresponse_id c_rfqresponse.c_rfqresponse_id Cascade on delete 
crfqtopic_crfq c_rfq.c_rfq_topic_id c_rfq_topic.c_rfq_topic_id Restrict delete 
crfqtopicsubscriber_only c_rfq_topicsubscriberonly.c_rfq_topicsubscriber_id c_rfq_topicsubscriber.c_rfq_topicsubscriber_id Cascade on delete 
cuom_crfqlineqty c_rfqlineqty.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_mproduct m_product.c_uom_id c_uom.c_uom_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 
linkorder_corder c_order.link_order_id c_order.c_order_id Restrict delete 
masetinstance_crfqline c_rfqline.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattrsetinst_mproduct m_product.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict 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 
mpricelistversionbase_mpriceli m_pricelist_version.m_pricelist_version_base_id m_pricelist_version.m_pricelist_version_id Restrict delete 
mprodcategory_crfqtsubonly c_rfq_topicsubscriberonly.m_product_category_id m_product_category.m_product_category_id Restrict delete 
mproduct_cbpproduct c_bpartner_product.m_product_id m_product.m_product_id Cascade on delete 
mproduct_crfqline c_rfqline.m_product_id m_product.m_product_id Restrict delete 
mproduct_crfqtsubonly c_rfq_topicsubscriberonly.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 
mproductcat_parentcat m_product_category.m_product_category_parent_id m_product_category.m_product_category_id Restrict delete 
quotationorder_corder c_order.quotationorder_id c_order.c_order_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 

Check Constraints:

Table Constraint Name Constraint
None detected