Im building a foosball game logging site, and need some advice on how to layout the database. What I need help with is how to build the relations with these conditions in mind:
team = colors, each team can have different players in each game. In "game 1" players 1 & 2 can be in "team 1", but in "game 2" the "team 1" can consist of players 3 & 4.This is the DB layout so far:
Users/Players:
idusernameTeams/Colors:
idnameGames:
idteam1_idteam2_idteam1_scoreteam2_scoreWhich additional table(s) do I need to add to make this work "the laravel way"?
Normally I would add a table with game_id, user_id and team_id columns, but I guess there is a cleaner solution with laravel.