baduk

Tables (5)

AI_Analyze

  • report_id — INT — Primary key
  • record_id — INT — Foreign key → Record.record_id
  • match_id — INT — Foreign key → Game_Match.match_id
  • user_id — VARCHAR(20) — Foreign key → Baduk_User.user_id
  • engine_name — VARCHAR(50)
  • win_rate_trend — TEXT
  • blunder_count — INT
  • best_move — VARCHAR(50)

Baduk_User

  • user_id — VARCHAR(20) — Primary key
  • nick_name — VARCHAR(50)
  • email — VARCHAR(100)
  • grade_level — VARCHAR(10)
  • rating_elo — INT
  • join_date — DATE

Game_Match

  • match_id — INT — Primary key
  • black_player_id — VARCHAR(20)
  • white_player_id — VARCHAR(20)
  • user_id — VARCHAR(20) — Foreign key → Baduk_User.user_id
  • game_datetime — DATETIME
  • match_result — VARCHAR(30)
  • komi_value — DECIMAL(2,1)

Record

  • record_id — INT — Primary key
  • match_id — INT — Foreign key → Game_Match.match_id
  • user_id — VARCHAR(20) — Foreign key → Baduk_User.user_id
  • total_moves — INT
  • sgf_path — VARCHAR(255)
  • competition_name — VARCHAR(100)
  • created_at — DATETIME

Subscription

  • sub_id — INT — Primary key
  • user_id — VARCHAR(20) — Foreign key → Baduk_User.user_id
  • plan_grade — VARCHAR(20)
  • start_date — DATE
  • end_date — DATE
  • status_code — VARCHAR(15)