NF2.1 Model Cascade Delete

Feature: Model Cascade Delete

Goal: Technical

Description:

iDempiere allows to define foreign key constraints on database. In addition to the options implemented with DB Objects in Dictionary, a new option for Model Cascade has been implemented, so the new list is as follows:

• No Action: This is the default, when the parent record is deleted it will throw an exception if there are child records
• Do Not Create: Do not create this constraint, not recommended, it can lead to data errors, the parent can be deleted without any notice leaving orphan children in the database

Also to change the behavior on children records you can use:

• Cascade: When the parent record is deleted then the child records on this constraint will be deleted too (if possible) - this constraint is executed in the database, consequently the business model rules are not triggered (workflows, changelog, etc)
• Model Cascade: When the parent record is deleted then the child records on this constraint will be deleted too (if possible) - this constraint is executed within iDempiere, so all business model rules are applied.
• Set Null: When the parent record is deleted then the child records on this constraint will set to null (if possible)

Technical Info: IDEMPIERE-2060