SchemaSpy Analysis of idempiere9.adempiere - ConstraintsCRM Generated by
Quality Systems & Solutions
10 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
cbplocation_cproject c_project.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
ccampaign_copportunity c_opportunity.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_cproject c_project.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccycle_ccyclestep c_cyclestep.c_cycle_id c_cycle.c_cycle_id Cascade on delete 
copportunity_ccontactactivity c_contactactivity.c_opportunity_id c_opportunity.c_opportunity_id Restrict delete 
cpaymentterm_cproject c_project.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cphase_cproject c_project.c_phase_id c_phase.c_phase_id Restrict delete 
cproject_cprojectline c_projectline.c_project_id c_project.c_project_id Cascade on delete 
csalesstage_copportunity c_opportunity.c_salesstage_id c_salesstage.c_salesstage_id Restrict delete 
rinterestarea_rcontactinterest r_contactinterest.r_interestarea_id r_interestarea.r_interestarea_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected