16

Tables (4)

BoardPosition

  • position_id — INT
  • name — VARCHAR(20) — NOT NULL
  • x — INT
  • y — INT

Game

  • game_id — INT
  • start_time — DATETIME — NOT NULL
  • status — ENUM('waiting', 'in_progress', 'finished')

Piece

  • piece_id — INT
  • player_id — INT
  • current_position_id — INT
  • is_finished — BOOLEAN

Player

  • player_id — INT
  • game_id — INT
  • name — VARCHAR(50) — NOT NULL
  • color — VARCHAR(20)