16
Tables (7)
Board
- board_id — INT — Primary key
- game_id — INT — NOT NULL
- game_id (game_id2) — INT — Foreign key → Game.game_id
Game
- game_id — INT — Primary key
- winner_player_id (player_id2) — INT — Foreign key → Player.player_id
- board_type — ENUM('SQUARE', 'PENTAGON', 'HEXAGON') — NOT NULL
- num_players — INT — NOT NULL
- num_pieces — INT — NOT NULL
- state — ENUM('SETUP', 'PLAYING', 'FINISHED')
- current_turn_player_id — INT
PathNode
- board_id (board_id2) — INT — Foreign key → Board.board_id
- node_id — INT
- x_coord — INT — NOT NULL
- y_coord — INT — NOT NULL
- next_node_id — INT
- is_center — BOOLEAN
- is_start_or_end — BOOLEAN
Piece
- piece_id — INT — Primary key
- player_id (player_id2) — INT — Foreign key → Player.player_id
- position — VARCHAR(30)
- is_finished — BOOLEAN
- is_grouped — BOOLEAN
- group_id — BIGINT
- state — ENUM('START', 'ON_BOARD', 'FINISHED')
Player
- player_id — INT — Primary key
- name — VARCHAR(50) — NOT NULL
- color — VARCHAR(20)
- num_of_pieces — INT — NOT NULL
- finished_count — INT
Turn
- turn_id — INT — Primary key
- result — ENUM('BACK_DO', 'DO', 'GAE', 'GEOL', 'YUT', 'MO') — NOT NULL
- chosen_piece_id — INT
- game_id (game_id2) — INT — Foreign key → Game.game_id
- player_id — INT — Foreign key → Player.player_id
TurnAction
- action_id — INT — Primary key
- turn_id (turn_id2) — INT — Foreign key → Turn.turn_id
- move_order — INT — NOT NULL
- result — ENUM('BACK_DO', 'DO', 'GAE', 'GEOL', 'YUT', 'MO') — NOT NULL
- is_used — BOOLEAN
- chosen_piece_id — INT