chess

Tables (5)

Untitled (piece)

  • Key (piece_id) — bigint — Primary key — NOT NULL
  • Field (type) — varchar(255)

Untitled (team)

  • Key (team_id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(255)

Untitled (game_room)

  • Key (game_room_id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Key (game_state_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (game_state)

  • Key (game_state_id) — bigint — Primary key — NOT NULL
  • Field (state) — varchar(255) — NOT NULL

board

  • Key (board_id) — bigint — Primary key — NOT NULL
  • Field (position_x) — bigint — NOT NULL
  • Field (position_y) — bigint — NOT NULL
  • Key (game_room_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (piece_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (team_id) — bigint — Foreign key → Untitled.Key — NOT NULL