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