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)