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