11
Tables (23)
ai_prediction
- ai_prediction_id — BIGINT — Primary key — NOT NULL
- match_id — BIGINT — Foreign key → match_game.match_id — NOT NULL
- home_win_probability — FLOAT — NOT NULL
- draw_probability — FLOAT — NOT NULL
- away_win_probability — FLOAT — NOT NULL
board
- board_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id
- category — VARCHAR(20) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT — NOT NULL
- like_count — INT — NOT NULL
board_image
- board_image_id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → board.board_id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
board_like
- board_like_id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → board.board_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
comment
- comment_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id
- target_type — VARCHAR(20) — NOT NULL
- target_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
comment_report
- comment_report_id — BIGINT — Primary key — NOT NULL
- comment_id — BIGINT — Foreign key → comment.comment_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id
email_verification
- email_verification_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- verification_code — VARCHAR(10) — NOT NULL
- purpose — VARCHAR(20) — NOT NULL
- is_verified — TINYINT(1) — NOT NULL
- expires_at — DATETIME — NOT NULL
filter_log
- filter_log_id — BIGINT — Primary key — NOT NULL
- target_type — VARCHAR(20) — NOT NULL
- target_id — BIGINT — NOT NULL
- action — VARCHAR(20) — NOT NULL
match_event
- match_event_id — BIGINT — Primary key — NOT NULL
- match_id — BIGINT — Foreign key → match_game.match_id — NOT NULL
- player_id — BIGINT — Foreign key → player.player_id
- event_type — VARCHAR(30) — NOT NULL
- event_time — INT
match_favorite
- match_favorite_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- match_id — BIGINT — Foreign key → match_game.match_id — NOT NULL
match_game
- match_id — BIGINT — Primary key — NOT NULL
- sport_id — BIGINT — Foreign key → sport.sport_id — NOT NULL
- home_team_id — BIGINT — Foreign key → team.team_id — NOT NULL
- away_team_id — BIGINT — Foreign key → team.team_id — NOT NULL
- scheduled_at — DATETIME — NOT NULL
- status — VARCHAR(20) — NOT NULL
- home_score — INT — NOT NULL
- away_score — INT — NOT NULL
match_lineup
- match_lineup_id — BIGINT — Primary key — NOT NULL
- match_id — BIGINT — Foreign key → match_game.match_id — NOT NULL
- player_id — BIGINT — Foreign key → player.player_id — NOT NULL
- is_starter — TINYINT(1) — NOT NULL
match_stat
- match_stat_id — BIGINT — Primary key — NOT NULL
- match_id — BIGINT — Foreign key → match_game.match_id — NOT NULL
- team_id — BIGINT — Foreign key → team.team_id — NOT NULL
- player_id — BIGINT — Foreign key → player.player_id
- kills — INT
- assists — INT
- deaths — INT
news
- news_id — BIGINT — Primary key — NOT NULL
- sport_id — BIGINT — Foreign key → sport.sport_id
- related_team_id — BIGINT — Foreign key → team.team_id
- related_player_id — BIGINT — Foreign key → player.player_id
- title — VARCHAR(300) — NOT NULL
- news_url — VARCHAR(500) — NOT NULL
news_scrap
- news_scrap_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- news_id — BIGINT — Foreign key → news.news_id — NOT NULL
player
- player_id — BIGINT — Primary key — NOT NULL
- team_id — BIGINT — Foreign key → team.team_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- position — VARCHAR(30)
- jersey_number — INT
prediction
- prediction_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id
- match_id — BIGINT — Foreign key → match_game.match_id — NOT NULL
- predicted_result — VARCHAR(20) — NOT NULL
social_login
- social_login_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_uid — VARCHAR(255) — NOT NULL
sport
- sport_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- code — VARCHAR(20) — NOT NULL
team
- team_id — BIGINT — Primary key — NOT NULL
- sport_id — BIGINT — Foreign key → sport.sport_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- location — VARCHAR(100)
- emblem_url — VARCHAR(500)
team_season_stat
- team_season_stat_id — BIGINT — Primary key — NOT NULL
- team_id — BIGINT — Foreign key → team.team_id — NOT NULL
- season — VARCHAR(20) — NOT NULL
- wins — INT
- draws — INT
- losses — INT
- ranking — INT
user_notification_setting
- user_notification_setting_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- match_start_alert — TINYINT(1) — NOT NULL
- prediction_result_alert — TINYINT(1) — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(20) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(20) — NOT NULL
- nickname — VARCHAR(20)
- phone — VARCHAR(20)
- birth_date — DATE
- profile_image_url — VARCHAR(500)
- marketing_agreed — TINYINT(1) — NOT NULL
- is_deleted — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL