Multiple Many-To-Many Tables
Hello,
I am familiar with using a junction table for a "many-to-many" relationship.
However, I'm not exactly sure how I could string multiple "many-to-many" or
junction tables into an architecture.
Does anyone have a suggestion?
For instance, I may have members that are assigned to many projects (and
each project many members). But I also have boards that have multiple
priorities and multiple priorities are linked to multiple organizations.
Currently, I'm myself trying to figure out the relationships between all the
entities. Again, knowing how I could use (with a generic example) multiple
junction tables would be great advice.
Thanks,
Tom
|