Referential Integrity for CCK | drupal.org

We encountered the necessity for referemtial integrity of nodereference fields in the PDonline project. To prevent deletion of nodes that are referenced by others there is no backend solution. Neither does this promising new project implement it so far. It seems to be an impossible task given the way the hook system and the database layer are designed.

This module provides a method to enforce referential integrity rules for CCK user and node reference fields.

Once installed, the user and node reference field settings form will provide a new option "Referential integrity behavior". For the moment, the options available are:

- None (default).
- Set NULL (Set the value of this field to NULL when referenced users/nodes are deleted).

A brief but sufficient explanation of standard SQL integrity actions can be found in the Doctrine documentation.