On Sat, Jan 31, 2009 at 03:45:38PM -0500, Michael LeSauvage wrote:
> Keep in mind whilst reading this that I have essentially no SQL background.
You are welcome!
> - When I use a MultipleJoin/Foreign Key relationship between two tables,
> are any columns or tables created to support this relationship? I suspect
> that this is simply a nice way of hiding a select query.
Yes, a new field, int FOREIGN KEY, is created in the table where the
ForeignKey column is declared. MultipleJoin column is not a real column,
but a mark for SQLObject to know what ForeignKey points to it.
> - When I use a RelatedJoin relationship between two tables, what happens
> at the SQL level? I think an intermediate table is created. What's in this
> table?
Yes, there is a hidden table with two columns - two FOREIGN KEYs pointing
to both tables. If you want to create the table yourself to control what is
in the table, see
http://sqlobject.org/FAQ.html#how-can-i-define-my-own-intermediate-table-in-my-many-to-many-relationship
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ ph...@ph...
Programmers don't die, they just GOSUB without RETURN.
|
