[ orm-Feature Requests-1602869 ] Compound subset constraints not enforced in SQL

[SourceForge.net <no...@so...>]

Feature Requests item #1602869, was opened at 2006-11-26 09:49
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=809611&aid=1602869&group_id=158881

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Clifford Heath (cjheath)
Assigned to: Nobody/Anonymous (nobody)
Summary: Compound subset constraints not enforced in SQL

Initial Comment:
Example:

Student(Name) is enrolled in School(Name)
School(Name) sanctions Activity(Name)
Student participates in Activity that is
sanctioned by School.
If some Student partipates in some Activity
which is sanctioned by some School then that
Student is enrolled in that School.

This last fact (a subset constraint) is not
enforced in the generated SQL. It probably
needs a trigger on the participation table
to ensure correct enrollment.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=809611&aid=1602869&group_id=158881