This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
What would be the best way to map the following many-to-many situation?
I want to map User (userId, username, password, firstname, lastname, roles)
Role (roleId, name)
A role is really just a name and the system contains 4 roles (admin, user, etc). Each User can have one or more roles, and each Role can be assigned to one or more Users. These roles never change, so what I need in the database is a USER table with user data and a ROLE table with just 4 records that never change and an association table between them.
Is there a way to specify the roles in a HBM mapping, kinda like an Enum?
OMG. The Netherlands is playing against Brazil, so thanks in advance for your responses, I'll read them in a couple of hours.