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