Hmm... Entity qualifiers introduced in 1.1 would've worked, except that
they are supported for ObjEntities only. So no luck here.
I guess nobody cared to implement this, since having a separate join table
for each n:m is arguably cleaner design and makes db data maintenance
easier. But I'd like to hear arguments in favor of such generic join table
design.
Andrus
> I would like to create a generic relationship table to handle my
> many-to-many relationships.
>
> For example:
> Charge to Order (n:m)
> Charge to Charge (n:m)
>
> I would like to have a single table for the flattened relationships.
> That relationship table would have a "type" column that would be used to
> differentiate between the different relationships.
>
> So I would have something like in the Rel table:
>
> Charge ID "Charge-Order" Order ID
> Charge A ID "Charge-Charge" Charge B ID
>
> Is this possible? Any suggestions?
This archive was generated by hypermail 2.0.0 : Mon May 03 2004 - 13:24:31 EDT