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

Constraint Name Child Column Parent Column Delete Rule
aasset_aassetuse a_asset_use.a_asset_id a_asset.a_asset_id Restrict delete 
aasset_moperationresource m_operationresource.a_asset_id a_asset.a_asset_id Restrict delete 
ad_user_org ad_user.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_adorginfo ad_orginfo.ad_org_id ad_org.ad_org_id Cascade on delete 
adorgparent_adorginfo ad_orginfo.parent_org_id ad_org.ad_org_id Null on delete 
adorgtrx_aduser ad_user.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
aduser_aasset a_asset.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_adorginfo ad_orginfo.supervisor_id ad_user.ad_user_id Null on delete 
aduser_adusersub ad_user_substitute.ad_user_id ad_user.ad_user_id Cascade on delete 
aduser_cjobassignment c_jobassignment.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_cuserremuneration c_userremuneration.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_supervisor ad_user.supervisor_id ad_user.ad_user_id Restrict delete 
adusersub_ad_usersub ad_user_substitute.substitute_id ad_user.ad_user_id Cascade on delete 
aparentasset_aasset a_asset.a_parent_asset_id a_asset.a_asset_id Restrict delete 
cjob_aduser ad_user.c_job_id c_job.c_job_id Restrict delete 
cjob_cjobassignment c_jobassignment.c_job_id c_job.c_job_id Restrict delete 
cjob_cjobremuneration c_jobremuneration.c_job_id c_job.c_job_id Restrict delete 
cjob_moperationresource m_operationresource.c_job_id c_job.c_job_id Restrict delete 
cremuneration_cjobrem c_jobremuneration.c_remuneration_id c_remuneration.c_remuneration_id Restrict delete 
cremuneration_cuserrem c_userremuneration.c_remuneration_id c_remuneration.c_remuneration_id Restrict delete 
mbom_mbomproduct m_bomproduct.m_bom_id m_bom.m_bom_id Cascade on delete 
mproductop_mbomproduct m_bomproduct.m_productoperation_id m_productoperation.m_productoperation_id Restrict delete 
mproductop_mopresource m_operationresource.m_productoperation_id m_productoperation.m_productoperation_id Cascade on delete 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected