janggi

Tables (4)

piece

  • piece_id (Key) — int — Primary key — NOT NULL
  • y (Field) — int — NOT NULL
  • x (Field2) — int
  • team (Key2) — int — Foreign key → team.team_id — NOT NULL
  • piectype_id (Key3) — int — Foreign key → piecetype.piectype_id — NOT NULL

piecetype

  • piectype_id (Key) — int — Primary key — NOT NULL
  • name (Field) — Enum — NOT NULL — CANNON, CHARIOT, SOLDIER, ELEPHANT, GUARD, HORSE, KING

team

  • team_id (Key) — int — Primary key — NOT NULL
  • name (Field) — Enum — NOT NULL — HAN, CHO

turn

  • turn_id (Key) — int — Primary key — NOT NULL
  • current_team (Key2) — int — Foreign key → team.team_id — NOT NULL