w2p
Tables (7)
Untitled (USER_DISLIKE)
- Key (user_id) — VARCHAR(50) — Foreign key → user_info.Key — NOT NULL
- Field (category_id) — VARCHAR(50)
Untitled (GAME_SUBGENRE)
- appId — VARCHAR(300) — Foreign key → game_info.appId — NOT NULL
- Field (subgenre_id) — VARCHAR(300)
game_info (GAME_INFO)
- appId — VARCHAR(300) — Primary key — NOT NULL
- Field
game_rating (GAME_RATING)
- appId — VARCHAR(300) — Foreign key → game_info.appId — NOT NULL
- Key (user_id) — VARCHAR(50) — Foreign key → user_info.Key — NOT NULL
- Field (game_score) — INT
- Field (rate_date) — DATE
game_recommend (GAME_RECOMMEND)
- appId — VARCHAR(300) — Foreign key → game_info.appId — NOT NULL
- Key (user_id) — VARCHAR(50) — Foreign key → user_info.Key — NOT NULL
- Field (game_recommend) — INT
- Field (recommend_date) — DATE
type_info (TYPE_INFO)
- type_id — VARCHAR(20) — Primary key — NOT NULL
- Field (type_name) — VARCHAR(500)
- Field (type_img) — VARCHAR(500)
- Field (type_desc) — VARCHAR(500)
- Field (type_sub_name) — VARCHAR(500)
- Field (type_sub_desc) — VARCHAR(500)
user_info (USER_INFO)
- Key (user_id) — VARCHAR(50) — Primary key — NOT NULL
- Field (user_name) — VARCHAR(50)
- Field (user_ip) — VARCHAR(50)
- Field (user_date) — DATE
- Field (user_browser) — VARCHAR(50)
- Field
- type_id — VARCHAR(20) — Foreign key → type_info.type_id — NOT NULL