Hello!

I am a Hibernate newbie and I have this relation to include:


I have projects and I have users. One Project can have many Users and one User can be in many Projects, so I have a n:m relation between these two entities.

A User-Project relation is also "identified" by the role of a user in a project, for example "Project Manager", "Softare Developer", ... (there are 5-6 roles which are possible). But first, I am not sure if this is right to use this field "role" as a String in Java (varchar in MySQL) or should I create another entity called Role and map this to the table "ProjectUser"?
What do you think?

If I will do this in this kind how I illustrated it, I have used this for a bidirectional mapping:
http://tadtech.blogspot.com/2007/09/hib ... in_03.html

But there is no mapping of the additional data field, in my case "role". How can I integrate this in my annotations?

Thanks a lot in advcane & Best Regards PHANTOMIAS