DB

1. users
   • id, nom, prenom, mail (unique), externe, 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_sports
   • user_id, sport_id, created_at, updated_at
5. padel_games
   • id, is_double, game_date, game_hour, id_team_one, id_team_two, created_at, updated_at, deleted_at (nullable)
6. padel_games_scores
   • id, game_id, nb_sets, scores (tableau json : [{"set", "team1", "team2"}]), created_at, updated_at, deleted_at (nullable)
7. padel_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
8. padel_game_players
   • game_id, user_id, created_at, updated_at, deleted_at (nullable)
   • PK : game_id, user_id
9. padel_prices
   • id, ticket_value_cents, created_at, updated_at, deleted_at (nullable, unique)
10. padel_payments
    • id, user_id, admin_id, amount_paid_cents, ticket_value_cents, method ("cash", "cheque", "transer", "other"), payment_date, created_at, updated_at
11. padel_ticket_stock
    • id, admin_id, amount, created_at, updated_at