cm
Tables (3)
analysis
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- game_record_id — BIGINT — Foreign key → game_record.id — NOT NULL
- white_accuracy — DECIMAL(5, 2) — 0.00 ~ 100.00
- black_accuracy — DECIMAL(5, 2) — 0.00 ~ 100.00
- tree — JSON — NOT NULL — 분석 트리 (flat 배열, parentId로 연결)
- analyzed_at — DATETIME — NOT NULL
game_record
- id — BIGINT — Primary key — NOT NULL
- pgn — TEXT — NOT NULL — 전체 기보 (PGN)
- game_type — ENUM — NOT NULL
- white_player_id — BIGINT — Foreign key → users.id — EXTERNAL이면 NULL 가능
- black_player_id — BIGINT — Foreign key → users.id — EXTERNAL이면 NULL 가능
- source — VARCHAR(50) — 외부 출처 (예: lichess)
- external_id — VARCHAR(100) — 외부 시스템의 게임 ID
- result_reason — ENUM
- created_at — DATETIME — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- elo_rating — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL