SchemaSpy Analysis of idempiere9.adempiere - ConstraintsService Management Generated by
Quality Systems & Solutions
45 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
basepricelist m_pricelist.basepricelist_id m_pricelist.m_pricelist_id Restrict 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 
cbpartner_stimeexpense s_timeexpense.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_stimeexpenseline s_timeexpenseline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cinvoiceline_stimeexpenseline s_timeexpenseline.c_invoiceline_id c_invoiceline.c_invoiceline_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_ref c_orderline.ref_orderline_id c_orderline.c_orderline_id Restrict delete 
corderline_stimeexpenseline s_timeexpenseline.c_orderline_id c_orderline.c_orderline_id Restrict delete 
cservicelevel_line c_servicelevelline.c_servicelevel_id c_servicelevel.c_servicelevel_id Cascade on delete 
ctaxcategory_mproduct m_product.c_taxcategory_id c_taxcategory.c_taxcategory_id Restrict delete 
ctaxcategory_sexpensetype s_expensetype.c_taxcategory_id c_taxcategory.c_taxcategory_id Restrict delete 
ctaxcategory_sresourcetype s_resourcetype.c_taxcategory_id c_taxcategory.c_taxcategory_id Restrict delete 
cuom_cinvoiceline c_invoiceline.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_corderline c_orderline.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_mproduct m_product.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_sexpensetype s_expensetype.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_sresourcetype s_resourcetype.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_stimeexpenseline s_timeexpenseline.c_uom_id c_uom.c_uom_id Restrict delete 
linkorderline_corderline c_orderline.link_orderline_id c_orderline.c_orderline_id Restrict delete 
mpricelist_cbpartner c_bpartner.m_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mpricelist_stimeexpense s_timeexpense.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 
mprodcategory_sresourcetype s_resourcetype.m_product_category_id m_product_category.m_product_category_id Restrict 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_cservicelevel c_servicelevel.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_stimeexpenseline s_timeexpenseline.m_product_id m_product.m_product_id Restrict delete 
mproductcat_parentcat m_product_category.m_product_category_parent_id m_product_category.m_product_category_id Restrict delete 
mproductcategory_sexpensetype s_expensetype.m_product_category_id m_product_category.m_product_category_id Restrict delete 
mwarehouse_corderline c_orderline.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_sresource s_resource.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_stimeexpense s_timeexpense.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehousesource_mwarehouse m_warehouse.m_warehousesource_id m_warehouse.m_warehouse_id Restrict delete 
sexpensetype_mproduct m_product.s_expensetype_id s_expensetype.s_expensetype_id Restrict delete 
sresource_mproduct m_product.s_resource_id s_resource.s_resource_id Restrict delete 
sresource_sresourceassignment s_resourceassignment.s_resource_id s_resource.s_resource_id Restrict delete 
sresource_sresunavailable s_resourceunavailable.s_resource_id s_resource.s_resource_id Cascade on delete 
sresourceassign_cinvoiceline c_invoiceline.s_resourceassignment_id s_resourceassignment.s_resourceassignment_id Restrict delete 
sresourceassign_corderline c_orderline.s_resourceassignment_id s_resourceassignment.s_resourceassignment_id Restrict delete 
sresourceassign_steline s_timeexpenseline.s_resourceassignment_id s_resourceassignment.s_resourceassignment_id Restrict delete 
sresourcetype_sresource s_resource.s_resourcetype_id s_resourcetype.s_resourcetype_id Cascade on delete 
stimeexpense_line s_timeexpenseline.s_timeexpense_id s_timeexpense.s_timeexpense_id Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected