SchemaSpy Analysis of idempiere11.adempiere - ConstraintsPOS Generated by
Quality Systems & Solutions
31 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
adprintcolor_cposkey c_poskey.ad_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor_cposkeylayout c_poskeylayout.ad_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
aduser_cpos c_pos.salesrep_id ad_user.ad_user_id Restrict delete 
aduser_supervisor ad_user.supervisor_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 
cbpartner_aduser ad_user.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_cpayment c_payment.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnercashtrx_cpos c_pos.c_bpartnercashtrx_id c_bpartner.c_bpartner_id Restrict delete 
cdoctype_cpayment c_payment.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_cpos c_pos.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_invoice c_doctype.c_doctypeinvoice_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 
cposkeylayout_c_poskey c_poskey.c_poskeylayout_id c_poskeylayout.c_poskeylayout_id Cascade on delete 
cposkeylayout_cpos c_pos.c_poskeylayout_id c_poskeylayout.c_poskeylayout_id Restrict delete 
mpricelist_cbpartner c_bpartner.m_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mpricelist_cpos c_pos.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 
mproduct_cposkey c_poskey.m_product_id m_product.m_product_id Restrict delete 
mwarehouse_cpos c_pos.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehousesource_mwarehouse m_warehouse.m_warehousesource_id m_warehouse.m_warehouse_id Restrict delete 
oskkeylayout_cpos c_pos.osk_keylayout_id c_poskeylayout.c_poskeylayout_id Restrict delete 
osnpkeylayout_cpos c_pos.osnp_keylayout_id c_poskeylayout.c_poskeylayout_id Restrict delete 
refpayment_cpayment c_payment.ref_payment_id c_payment.c_payment_id Restrict delete 
reversal_cpayment c_payment.reversal_id c_payment.c_payment_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 
subkeylayout_cposkey c_poskey.subkeylayout_id c_poskeylayout.c_poskeylayout_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected