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)
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