Topic: Three-way model relationship
I have a small problem with model relations that I'd like some help to work out. Bacically I have a "Projects" model which is made up of "organizations" with specific "roles". Every project can have many organizations contributing, each with a specific role. Also, an organization can have different roles for different projects. I have three tables (projects, organizations, and roles) and I'm thinking about adding a fourth called, say, Assignments, that would contain the foreign keys for all three tables.
So I'm kinda stuck in a decision to go with a habtm or a :through relationship between the three entities.