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, role (user, admin), 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-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
- padel-prices
- id, price, created_at, updated_at, deleted_at (nullable, unique)
- padel-billing
- id, user_id, admin_id, amount, created_at, updated_at