SchemaSpy Analysis of idempiere11.adempiere - ConstraintsResource Management Generated by
Quality Systems & Solutions
21 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
ad_org_c_acctschema c_acctschema.ad_org_id ad_org.ad_org_id Restrict delete 
ad_org_mproduct m_product.ad_org_id ad_org.ad_org_id Restrict delete 
ad_user_org ad_user.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_corgassignment c_orgassignment.ad_org_id ad_org.ad_org_id Restrict delete 
adorgonly_cacctschema c_acctschema.ad_orgonly_id ad_org.ad_org_id Restrict delete 
adorgtrx_aduser ad_user.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
aduser_corgassignment c_orgassignment.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_sresource s_resource.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_supervisor ad_user.supervisor_id ad_user.ad_user_id Restrict delete 
c_nonbusinesdaysorg c_nonbusinessday.ad_org_id ad_org.ad_org_id Restrict delete 
cacctschema_mproductacct m_product_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
m_product_m_product_acct m_product_acct.m_product_id m_product.m_product_id Cascade on delete 
mproduct_stimeexpenseline s_timeexpenseline.m_product_id m_product.m_product_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 
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_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 
stimetype_stimeexpenseline s_timeexpenseline.s_timetype_id s_timetype.s_timetype_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected