Hi all, I've a problem with a relationship that have more than 2 join columns.
The scenario is as follows. The underlined text is primary key
Shooters (shooterId,name) Matches(MatchId,name) Categories(CategoryId,name)
In fact, one shooter can join on multiple matches. And one shooter can join on multiple categories for the same match. So I need the following table
Registration(shooterId,MatchId,CategoryId,score)
If I had only two table, I know how to solve this scenario with ManyToMany relationship. I use always the Annotations and I've found some examples that explain the case of two tables, but not for more than two tables. Now, in this case I've three table and I don't understand how to solve this problem.
thanks to all the people who help me
|