WebGameRanking

Tables (4)

game_list

  • game_id — bigint(20) — Primary key — NOT NULL
  • game_name — varchar(255) — NOT NULL

score

  • score_id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.user_id — NOT NULL
  • game_id — bigint(20) — Foreign key → game_list.game_id — NOT NULL
  • score — bigint(20) — NOT NULL
  • played_time — datetime — NOT NULL

session

  • session_id — bigint(20) — Primary key — NOT NULL
  • session — varchar(255) — NOT NULL

user

  • user_id — bigint(20) — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • profile_image_url — varchar(255)