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