Need help with objects/lists?

Options
tbjackson
tbjackson Member
edited June 2023 in ? Help! I'm a Noob

Hi all,

Working on adding some group functionality to my app. It's a youth sports app where coaches and athletes get assigned to a team. Now I need to add groups within those teams.

I added a [team groups] table where I am linking Team ID and then adding the respective name of the groups. The issue now is really how I handle assigning multiple of these groups to coaches.

On the athlete side they will only get assigned one group per team for now.

Best Answer

  • Pawel Magdanski
    Pawel Magdanski Member ✭✭✭
    Answer ✓
    Options

    Hi,

    If the whole team always has the same coach then you can add a relation to the coach at the team level, if different groups within a team may have different coaches, then you want to add coach_id on the group level.

    Hope that helped, if I'm missing something please let me know.