CCK is heading towards enabling application design within Drupal. One feature that would be nice is the (optional) ability to enforce referential integrity for nodereference and userreference.
Has anyone done any thinking/ planning on this? What would this mean for Content Nodes?
If a content node A refers to node B (or user B) then Drupal could guarantee that node A does not get orphaned. This can happen in two ways. 1) Prevention of deletion of node B (user B) while the reference exists or 2) cascading the node deletion.
Love to hear from other developers on this idea.