dd

Tables (12)

court

  • id — BIGINT
  • gym_id — BIGINT
  • court_number — INT
  • created_at — DATETIME
  • updated_at — DATETIME

gym

  • id — BIGINT
  • address — VARCHAR(255)
  • contact_number — VARCHAR(100)
  • description — VARCHAR(255)
  • image — VARCHAR(255)
  • name — VARCHAR(100)
  • region — VARCHAR(50)
  • url — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

gym_admin

  • id — BIGINT
  • cumulative_income — INT
  • email — VARCHAR(100)
  • nickname — VARCHAR(50)
  • number — VARCHAR(20)
  • password — VARCHAR(100)
  • gym_id — BIGINT
  • is_deleted — BOOLEAN
  • role — VARCHAR(50)
  • created_at — DATETIME
  • updated_at — DATETIME

manager

  • id — BIGINT
  • description — VARCHAR(255)
  • email — VARCHAR(100)
  • nickname — VARCHAR(50)
  • number — VARCHAR(20)
  • password — VARCHAR(100)
  • profile_img — VARCHAR(255)
  • is_deleted — BOOLEAN
  • role — VARCHAR(50)
  • created_at — DATETIME
  • updated_at — DATETIME

match

  • id — BIGINT
  • court_id — BIGINT
  • manager_id — BIGINT
  • match_date — DATE
  • match_time — TIME
  • match_type — VARCHAR(50)
  • rank_type — VARCHAR(50)
  • status — VARCHAR(50)
  • team1_set_score — INT
  • team2_set_score — INT
  • winner_team_number — INT
  • created_at — DATETIME
  • updated_at — DATETIME

match_set

  • id — BIGINT
  • match_id — BIGINT
  • set_number — INT
  • set_winner_team_number — INT
  • team1_score — INT
  • team2_score — INT
  • created_at — DATETIME
  • updated_at — DATETIME

password_history

  • id — BIGINT
  • player_id — BIGINT
  • changed_at — DATETIME
  • password — VARCHAR(100)

player

  • id — BIGINT
  • birth — DATE
  • description — VARCHAR(255)
  • email — VARCHAR(100)
  • game_count — INT
  • gender — VARCHAR(50)
  • image — VARCHAR(255)
  • lose_streak — INT
  • nickname — VARCHAR(50)
  • number — VARCHAR(20)
  • password — VARCHAR(100)
  • rating — INT
  • win_streak — INT
  • is_deleted — BOOLEAN
  • role — VARCHAR(50)
  • created_at — DATETIME
  • updated_at — DATETIME

racket

  • id — BIGINT
  • balance — VARCHAR(100)
  • color — VARCHAR(50)
  • image — VARCHAR(255)
  • manufacturer — VARCHAR(100)
  • material — VARCHAR(100)
  • name — VARCHAR(100)
  • price — INT
  • shaft — VARCHAR(100)
  • weight — VARCHAR(100)

rating_change

  • id — BIGINT
  • rating_change — INT
  • match_id — BIGINT
  • player_id — BIGINT

score

  • id — BIGINT
  • set_id — BIGINT
  • earned_player — INT
  • earned_type — VARCHAR(50)
  • missed_player1 — INT
  • missed_player2 — INT
  • missed_type — VARCHAR(50)
  • score_number — INT
  • created_at — DATETIME
  • updated_at — DATETIME

team

  • id — BIGINT
  • player_count — INT
  • rating — INT
  • created_at — DATETIME
  • updated_at — DATETIME