This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
I am posting my question here since I didn't get much of response in the other forum, and it is more relevant here, sorry for repeating the question:
Here is an example to explain my questions: let's say there is entity FOLDER that has a many to many relationship with GROUP. I could do the design as follows:
Where and How can I represent INFO? Is the following a better design (of courseDUMMY entity won't be named DUMMY!)? Personally I want to go for the first design but I don't know how to represent INFO field. In that case I define Folder and Group entities as follows: In Folder folder
Again how to access INFO column located in folder_group table? Some suggested that I could use two OneToMany relationships which is possible but I am trying to figure if there is a direct solution for the situation.