I'm designing a section of my database which links
Hunt. I would like users to be members of a team but the team can play multiple hunts (so can be used multiple times).
The first idea involves a 'HuntTeam' which links
Team directly however I need to know which users within the team will be playing so I've added a 'Player' table like below:
The second idea is to remove
HuntTeam completely and link
Player directly to
Hunt so it does the job of linking teams and users playing like below:
I'm worried that although the second option looks more simple, I would need to run quite a few 'belongs to through' or JOIN methods to reference the teams within a Hunt. Would it
Would you recommend one over the other and if so why? Perhaps you have an alternative solution?