On Thu, Jun 21, 2007 at 11:23:41AM -0700, Josh Anon wrote:
> Table: Model
> string name
> multiple join: poses
>
> Table: ModelPoses
> string poseName
> foreign key: model
>
> Now, I'd like to add a list of owners and notes to each of those
> tables w a definition like:
>
> # a list of notes
> Table: Notes
> string note
> sentBy: foreign key owner
> assignedTo: foreign key owner
>
> # a list of all users
> Table: Owner
> string email
[skip]
> * I can add a connection between notes.sentBy and notes.assignedTo to
> point to entries in Owner without having to add owner.sentNotes and
> owner.assignedTo keys
You probably want to add MultipleJoin fields to Owner.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
