Hi all,
Forgive me if this is a basic question, but I am new to SQLObject and
not seeing the answer in the docs.
Suppose I have a schema like:
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
What I haven't figured out how to do is create one way relationships
such that:
* I can add a list of notes and owners to model + model poses without
having to add any keys to the notes and owner tables--i care about
asking a model what notes it has and not asking the notes table what
model each note is associated with
* 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
(yes, I realize that these are basically the same question, but the
second case is slightly more complicated since there are 2 columns in
notes that points to owners)
thanks for any help!
Josh
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
