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