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, is_double, 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
  • game_id, user_one_id, user_two_id (nullable), state (V, N, D, nullable), nb_won_sets (nullable), created_at, updated_at, deleted_at (nullable)
  • PK : game_id, user_one_id, user_two_id