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:
multiple join: poses
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
sentBy: foreign key owner
assignedTo: foreign key owner
# a list of all users
What I haven't figured out how to do is create one way relationships
* 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
(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!
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
> * 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 Broytmann http://phd.pp.ru/ phd@...
Programmers don't die, they just GOSUB without RETURN.
Get latest updates about Open Source Projects, Conferences and News.