chess

Tables (4)

GAME (game)

  • Game-id (game-id) — bigint(20) — Primary key — NOT NULL
  • status
  • board-id

PartipateDetail (Participate-detail)

  • PartipateDetail-ID — bigint(20) — Primary key — NOT NULL
  • game-id — bigint(20) — Foreign key → GAME.Game-id — NOT NULL
  • USER-ID (user-id) — bigint(20) — Foreign key → User.USER-ID — NOT NULL
  • Field (color) — varchar(20)

User

  • USER-ID (user-id) — bigint(20) — Primary key — NOT NULL
  • NAME — VARCHAR(20)
  • WIN-COUNT — bigint(20)
  • LOSE-COUNT — bigint(20)
  • DRAW-COUNT (draw-count) — bigint(20)

board

  • board-id — bigint(20) — Primary key — NOT NULL
  • Field