Physical Test
Tables (3)
game (Untitled2)
- id (Key) — bigint(5) — Primary key — NOT NULL
- game_type (Field) — int(1) — NOT NULL
game_play (Untitled3)
- id (Key) — Primary key — NOT NULL
- game_id (Key2) — bigint(5) — Foreign key → game.id — NOT NULL
- user_id (Key3) — bigint(20) — Foreign key → user.id — NOT NULL
- score (Field) — bigint(5) — NOT NULL
- date_played (Field2) — datetime — NOT NULL
user (Untitled)
- id (Key) — bigint(20) — Primary key — NOT NULL
- password (Field) — varchar(255) — NOT NULL
- username (Field2) — varchar(15) — NOT NULL
- date_created (Field3) — datetime — NOT NULL
- date_withdraw (Field4) — datetime