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