> > A forth table that has four columns: its own primary key; three
> > foreign keys, one for each table. It is comparable to a many-to-many
> > relationship, but with three tables instead of just two.
> >
> > class FourthTable(SQLObject):
> > first = ForeignKey("FirstTable")
> > second = ForeignKey("SecondTable")
> > third = ForeignKey("ThirdTable")
> >
> > Not sure why you would want to do this. Perhaps there are relations
> > between any two table that should be flushed out first?
>
> Thanks a lot for the reply! The reason I want to do this is a kind of
> commenting system. There are 3 types of objects with totally different
> rows and methods each in its own table. But they share the feature
> that they can all be commented on. Comments are stored in a separate
> table but that table has to have a row which refers to the object the
> given comment belongs to. And this object can be in any of the 3
> tables.
>
> So how would I connect a comment to the object it refers?
And I forgot to say that I would like to have a solution such that if
new objects are added (i.e. new tables are added) that also can be
commented on then I don't want to redesign anything. In the ideal case
I would set something on the new table that indicates that this table
(object) can be commented on and that should be it.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
