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