SchemaSpy Analysis of idempiere11.adempiere - ConstraintsRequisition / Demand Generated by
Quality Systems & Solutions
72 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
aduser_corder c_order.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_mrequisition m_requisition.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 
basepricelist m_pricelist.basepricelist_id m_pricelist.m_pricelist_id Restrict delete 
c_calendar_year c_year.c_calendar_id c_calendar.c_calendar_id Restrict delete 
c_doctype_corder c_order.c_doctype_id c_doctype.c_doctype_id Restrict delete 
c_year_period c_period.c_year_id c_year.c_year_id Restrict delete 
cbpartner_aduser ad_user.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_ccashplan c_cashplan.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_ccashplanline c_cashplanline.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_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_mrequisitionline m_requisitionline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_soline c_orderline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnerbill_corder c_order.bill_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnerpay_corder c_order.pay_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
ccalendar_mdemand m_demand.c_calendar_id c_calendar.c_calendar_id Restrict delete 
ccalendar_mforecast m_forecast.c_calendar_id c_calendar.c_calendar_id Restrict delete 
ccashplan_ccashplanline c_cashplanline.c_cashplan_id c_cashplan.c_cashplan_id Restrict delete 
ccashplanline_corder c_order.c_cashplanline_id c_cashplanline.c_cashplanline_id Restrict delete 
ccharge_ccashplanline c_cashplanline.c_charge_id c_charge.c_charge_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_mrequisitionline m_requisitionline.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_mrequisition m_requisition.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 
cdoctypedifference_cdoctype c_doctype.c_doctypedifference_id c_doctype.c_doctype_id Restrict delete 
cdoctypetarget_corder c_order.c_doctypetarget_id c_doctype.c_doctype_id Restrict delete 
corder_corderline c_orderline.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_mdemanddetail m_demanddetail.c_orderline_id c_orderline.c_orderline_id Cascade on 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 
cperiod_mdemandline m_demandline.c_period_id c_period.c_period_id Restrict delete 
cperiod_mforecastline m_forecastline.c_period_id c_period.c_period_id Restrict delete 
cyear_mdemand m_demand.c_year_id c_year.c_year_id Restrict delete 
cyear_mforecast m_forecast.c_year_id c_year.c_year_id Restrict delete 
dropshipbpartner_corder c_order.dropship_bpartner_id c_bpartner.c_bpartner_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 Null on delete 
linkorderline_corderline c_orderline.link_orderline_id c_orderline.c_orderline_id Null on delete 
mdemand_mdemandline m_demandline.m_demand_id m_demand.m_demand_id Cascade on delete 
mdemandline_mdemanddetail m_demanddetail.m_demandline_id m_demandline.m_demandline_id Cascade on delete 
mforecast_mforecastline m_forecastline.m_forecast_id m_forecast.m_forecast_id Cascade on delete 
mforecastline_mdemanddetail m_demanddetail.m_forecastline_id m_forecastline.m_forecastline_id Cascade on delete 
mpricelist_cbpartner c_bpartner.m_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mpricelist_mforecast m_forecast.m_pricelist_id m_pricelist.m_pricelist_id Restrict 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 
mprocelist_mrequisition m_requisition.m_pricelist_id m_pricelist.m_pricelist_id Restrict delete 
mproduct_ccashplanline c_cashplanline.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_mdemandline m_demandline.m_product_id m_product.m_product_id Cascade on delete 
mproduct_mforecastline m_forecastline.m_product_id m_product.m_product_id Cascade on delete 
mproduct_mrequisitionline m_requisitionline.m_product_id m_product.m_product_id Restrict delete 
mreqline_mdemanddetail m_demanddetail.m_requisitionline_id m_requisitionline.m_requisitionline_id Cascade on delete 
mrequisition_mrequisitionline m_requisitionline.m_requisition_id m_requisition.m_requisition_id Cascade on 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_mforecastline m_forecastline.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_mrequisition m_requisition.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 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 
salesrep_mforecastline m_forecastline.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