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

Constraint Name Child Column Parent Column Delete Rule
adprintformat_cdunninglevel c_dunninglevel.dunning_printformat_id ad_printformat.ad_printformat_id Restrict delete 
adprintformatinv_cbpartner c_bpartner.invoice_printformat_id ad_printformat.ad_printformat_id Restrict delete 
aduser_cdunningrunentry c_dunningrunentry.ad_user_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 
cbpartner_aduser ad_user.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_cbplocation c_bpartner_location.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_cdunningrunentry c_dunningrunentry.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnerlocation_cdunningrune c_dunningrunentry.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbpgroup_cbpartner c_bpartner.c_bp_group_id c_bp_group.c_bp_group_id Restrict delete 
cbplocation_aduser ad_user.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
ccurrency_cdunningrunentry c_dunningrunentry.c_currency_id c_currency.c_currency_id Restrict delete 
cdunning_cbpartner c_bpartner.c_dunning_id c_dunning.c_dunning_id Restrict delete 
cdunning_cbpgroup c_bp_group.c_dunning_id c_dunning.c_dunning_id Restrict delete 
cdunning_cdunninglevel c_dunninglevel.c_dunning_id c_dunning.c_dunning_id Restrict delete 
cdunning_cdunningrun c_dunningrun.c_dunning_id c_dunning.c_dunning_id Restrict delete 
cdunninglevel_cdunningrun c_dunningrun.c_dunninglevel_id c_dunninglevel.c_dunninglevel_id Restrict delete 
cdunninglevel_cdunningrunentry c_dunningrunentry.c_dunninglevel_id c_dunninglevel.c_dunninglevel_id Restrict delete 
cdunningrun_cdunningrunentry c_dunningrunentry.c_dunningrun_id c_dunningrun.c_dunningrun_id Cascade on delete 
cdunningrunentry_line c_dunningrunline.c_dunningrunentry_id c_dunningrunentry.c_dunningrunentry_id Cascade on delete 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 
salesrep_cdunningrunentry c_dunningrunentry.salesrep_id ad_user.ad_user_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected