chessmate
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
- white_accuracy — DOUBLE — NOT NULL
- black_accuracy — DOUBLE — NOT NULL
- tree — TEXT — NOT NULL
- analyzed_at — DATETIME — NOT NULL
game_record
- id — BIGINT — Primary key — NOT NULL
- pgn — TEXT — NOT NULL
- game_type — VARCHAR(50) — NOT NULL
- white_player_id — BIGINT — Foreign key → users.id
- black_player_id — BIGINT — Foreign key → users.id
- winner — VARCHAR(20)
- result_reason — VARCHAR(50)
- source — VARCHAR(255)
- external_id — VARCHAR(255)
- created_at — DATETIME — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL