DB

1. users
   • id, nom, prenom, mail (unique), created_at, updated_at, deleted_at (nullable)
2. users_roles
   • user_id, role ("user", "padel-admin")
3. sports
   • id, nom (unique), created_at, updated_at, deleted_at (nullable)
4. users-sportsusers_sports
   • user_id, sport_id, role (user, admin), created_at, updated_at
5. padel-gamespadel_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)
6. padel-game-teamspadel_game_teams
   • game_id, user_one_id, user_two_id (nullable), side ("team1" ou "team2"), state (V, N, D, nullable), created_at, updated_at, deleted_at (nullable)
   • PK : game_id, user_one_id, user_two_id
7. padel-pricespadel_prices
   • id, price,ticket_value_cents, created_at, updated_at, deleted_at (nullable, unique)
8. padel-billingpadel_payments
   • id, user_id, admin_id, amount,amount_paid_cents, ticket_value_cents, payment_date, created_at, updated_at