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