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)