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