> 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?

-------------------------------------------------------------------------
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

Reply via email to