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)