Teams and group tables
Posted: Thu Jul 22, 2010 8:17 pm
Hello. I have an organization where the members are grouped in teams, which have a team leader, and big groups, which have a group leader.
It goes like this, one member can only have one team, meaning one team leader. One team (team leader) takes care of 1 or more than 1 members. 1 team can have 1 or 2 team helpers.
Each team is part of 1 group. Each group have a group leader. The group leader is in charge of 1 or more than 1 group leaders.
The way i have the tables set up is as follows:
Member Table : member_id, name, group_id, team_id, helper_id
Team Table: team_id, team_leader, team_helper, team_helper2
Groups Table: group_id, group_leader
I dont know if thats the best way to do it, I actually feel its not even close. Does anybody has any input? Thanks!
It goes like this, one member can only have one team, meaning one team leader. One team (team leader) takes care of 1 or more than 1 members. 1 team can have 1 or 2 team helpers.
Each team is part of 1 group. Each group have a group leader. The group leader is in charge of 1 or more than 1 group leaders.
The way i have the tables set up is as follows:
Member Table : member_id, name, group_id, team_id, helper_id
Team Table: team_id, team_leader, team_helper, team_helper2
Groups Table: group_id, group_leader
I dont know if thats the best way to do it, I actually feel its not even close. Does anybody has any input? Thanks!