Skip to main content
DB
- users
- id, nom, prenom, mail (unique), created_at, updated_at, deleted_at (nullable)
- sports
- id, nom (unique), created_at, updated_at, deleted_at (nullable)
- users-sports
- user_id, sport_id, created_at, updated_at
- padel-games
- id, nb_sets (nullable), scores (tableau json :
[{"set", "team1", "team2"}]
, nullable), id_team_one, id_team_two, created_at, updated_at, deleted_at (nullable)
- padel-teams
id,game_id, id_user_one,user_one_id, id_user_twouser_two_id (nullable), state (V, N, D, nullable), nb-won-setsnb_won_sets (nullable), created_at, updated_at, deleted_at (nullable)
- PK : game_id, user_one_id, user_two_id