Skip to main content

DB

  1. users
    • id, nom, prenom, mail (unique), created_at, updated_at, deleted_at (nullable)
  2. sports
    • id, nom (unique), created_at, updated_at, deleted_at (nullable)
  3. users-sports
    • user_id, sport_id, role (user, admin), created_at, updated_at
  4. 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)
  5. 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
  6. padel-prices
    • id, price, created_at, updated_at, deleted_at (nullable, unique)
  7. padel-billing
    • id, user_id, admin_id, amount, created_at, updated_at