Junction tables - Help simplify
Posted: Fri Jan 11, 2013 1:31 pm
May I get some help to simplify my database design? I am doing my first project a sports league website with the goal to learn PHP and MySQL.
To keep things simple I am using role based security.
Here are my tables
Users - id, Username, Password, FirstName, LastName, Email
Roles - id, Role
Users_Roles - id, UserId, RoleId
Leagues - id, Name, Alias
LeagueTypes - id, LeagueType
Seasons - id, Year
LeagueDetails - id, LeagueId, TypeId, SeasonId
Teams - id, Name, Alias
I am planning to use LeagueDetails as my table to link other relations.. eg. Teams under a league, League admins, etc.
For this I will need to make junction tables
Leagues_Teams - id, LeagueDetailId, TeamId
Leagues_Admins - id, LeagueDetailId, User_RolesId
Teams_Admins - id, TeamId, User_RolesId
Is there a simpler way of doing this? Am I making database model very complicated than it needs to be? Please advise
To keep things simple I am using role based security.
Here are my tables
Users - id, Username, Password, FirstName, LastName, Email
Roles - id, Role
Users_Roles - id, UserId, RoleId
Leagues - id, Name, Alias
LeagueTypes - id, LeagueType
Seasons - id, Year
LeagueDetails - id, LeagueId, TypeId, SeasonId
Teams - id, Name, Alias
I am planning to use LeagueDetails as my table to link other relations.. eg. Teams under a league, League admins, etc.
For this I will need to make junction tables
Leagues_Teams - id, LeagueDetailId, TeamId
Leagues_Admins - id, LeagueDetailId, User_RolesId
Teams_Admins - id, TeamId, User_RolesId
Is there a simpler way of doing this? Am I making database model very complicated than it needs to be? Please advise