baduk

Tables (11)

AI_Analysis

  • analysis_id — INT
  • sgf_id — INT — Foreign key → SGF_Data.sgf_id
  • ai_model_name — VARCHAR(50) — NOT NULL
  • win_rate_graph — TEXT
  • blunder_count — INT
  • recommended_move — VARCHAR(50)

AI_Analysis_Report

  • report_id — INT
  • record_id — INT — Foreign key → SGF_Record.record_id
  • engine_name — VARCHAR(50) — NOT NULL
  • win_rate_trend — TEXT
  • blunder_count — INT
  • best_move — VARCHAR(50)

Baduk_User

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

Game_Match

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

Match_History

  • match_id — INT
  • black_user_id — VARCHAR(20) — Foreign key → User.user_id
  • white_user_id — VARCHAR(20) — Foreign key → User.user_id
  • match_date — DATETIME — NOT NULL
  • result — VARCHAR(30) — NOT NULL
  • komi — DECIMAL(2,1)

Membership

  • membership_id — INT
  • user_id — VARCHAR(20) — Foreign key → User.user_id
  • grade — VARCHAR(20)
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • status — VARCHAR(15)

SGF_Data

  • sgf_id — INT
  • match_id — INT — Foreign key → Match_History.match_id
  • total_moves — INT — NOT NULL
  • sgf_file_path — VARCHAR(255) — NOT NULL
  • pro_match_title — VARCHAR(100)
  • created_at — DATETIME

SGF_Record

  • record_id — INT
  • match_id — INT — Foreign key → Game_Match.match_id
  • total_moves — INT — NOT NULL
  • sgf_path — VARCHAR(255) — NOT NULL
  • competition_name — VARCHAR(100)
  • created_at — DATETIME

Subscription

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

Untitled

    User

    • user_id — VARCHAR(20)
    • user_name — VARCHAR(50) — NOT NULL
    • email — VARCHAR(100) — NOT NULL
    • rank_level — VARCHAR(10)
    • rating_score — INT
    • join_date — DATE — NOT NULL