I design a section of my database that links
To hunt, I want users to be members of a team, but the team can run multiple hunts (so it can be used multiple times).
The first idea involves a & # 39; HuntTeam & # 39; linking
To hunt to
team directly but I have to know Which Users within the team will be playing, so I've added a & # 39; player & # 39; table like the following:
The second idea is to remove
Hunt team completely and link
player direct to
To hunt How to connect teams and users like this:
I'm worried that although the second option looks simpler, I've heard some & # 39; – or JOIN methods to reference the teams within a hunt. Would it
Would you recommend each other and if so, why? Maybe you have an alternative solution?