Relationship between users and roles

[stvnrlly]

In #10, we made users a foreign key on roles, but that doesn't feel quite right. Users and roles are separate, and should be combined inside of the acquisition. For example, one user may be the product lead on one project and a tech lead on another, but having an entry for every possibility feels a little heavy. This might involve customizing the User model.

[vdavez]

Are you saying that the Role class should include "Product Lead" and "Acquisitions Lead", and that there should be a separate class that combines the Role with the User?

[stvnrlly]

Yeah, I think that's it. Customizing the User model is probably not a good idea.

However, I think I was also imagining the roles as something wider, which I'm not sure is necessary. What's in there now should work well, so I think this issue should just be a prompt to think about this once we've used the tool a bit.