This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I'm not sure what you guys say, but what if it is possible to have "TypeId(Discriminator)" or something so you can have multiple relations from a object to another in the same ThroughAssociations table...perhaps this is ugly, but it could be a nice feature for the genious ThroughAssociations concept... |
|
|
|
|
Could you give an example of the sort of scenario you're thinking of? If all you want is multiple many-to-many relationships between objects of the same types -- say, Animal and Plant types with Edible and Poisonous relationships -- then you can do that with multiple through tables. (Though I guess you could argue that a single Animal-Plant-RelationshipType is more aesthetically pleasing than multiple relationship-specific Animal-Plant tables.) |
|
|
|
|
[quote user="ivan"]Could you give an example of the sort of scenario you're thinking of? If all you want is multiple many-to-many relationships between objects of the same types -- say, Animal and Plant types with Edible and Poisonous relationships -- then you can do that with multiple through tables.[/quote] Yeah, I do that today :-) The type was just a idea to have one table for example a Tag_ThroughAssociations without making a bunch of tables...but it will perhaps be better to have one table for each "link" |
|
|
|
