View Single Post
  #1  
Old May 13th, 2004, 04:22 AM
Tom
external usenet poster
 
Posts: n/a
Default 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