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?

-Brian

On 10/13/07, Daniel Fetchinson <[EMAIL PROTECTED]> wrote:
> Hi list,
>
> This might be slightly off-topic since I'm about to ask a general
> design question, not in any way sqlobject specific but please bear
> with me.
>
> I have 3 kinds of objects and each kind is stored in its own table.
> Using the primary key of each table I can refer to each object in that
> particular table. Now what I would like to have is a kind of primary
> key for all 3 tables so that by refering to a single key I would be
> able to select 1 object out of the 3 tables. Right now selection out
> of the 3 tables goes by first picking a table and then selecting an
> object from that table but I would like to have an over-arching id for
> any object.
>
> What would be the best strategy for this?
>
> -------------------------------------------------------------------------
> 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
>

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