chess

Tables (3)

Board (보드)

  • boardId (보드id) — Primary key — NOT NULL

Movement (경로)

  • notationId (경로id) — Primary key — NOT NULL
  • boardId (보드id) — Foreign key → Board.boardId — NOT NULL
  • source (출발지) — position(enum)
  • destination (도착지) — position(enum)

Square (칸)

  • gamePieceId (게임기물id) — Primary key — NOT NULL
  • boardId (보드id) — Foreign key → Board.boardId — NOT NULL
  • piece (기물) — piece(enum)
  • position (위치) — position(enum)