STEAM
Tables (5)
GAME_REVIEW
- app_id — bigint(20) — Primary key
- review_id — text
- review_text — text
- timestamp — datetime
- steam_purchase — tinyint(1)
- playtime_forever — double
- voted_up — tinyint(1)
- votes_up — bigint(20)
- weighted_vote_score — text
- app_id (app_id2) — bigint(20) — Foreign key → TITLELIST.app_id — NOT NULL
REVIEW_TAG
- id — int(11) — Primary key — NOT NULL
- app_id — int(11)
- review_id — text — NOT NULL
- game — int(11) — NOT NULL
- story — int(11) — NOT NULL
- graphics — int(11) — NOT NULL
- sound — int(11) — NOT NULL
- content — int(11) — NOT NULL
- originality — int(11) — NOT NULL
- stability — int(11) — NOT NULL
- convenience — int(11) — NOT NULL
- review_text — text
- app_id (app_id2) — bigint(20) — Foreign key → TITLELIST.app_id — NOT NULL
SIMILAR_GAMES
- game_app_id — bigint(20) — Primary key — NOT NULL
- recommended_app_id — bigint(20) — Primary key — NOT NULL
- recommended_title — varchar(255) — NOT NULL
- user_tags — text
- app_id (app_id2) — bigint(20) — Foreign key → TITLELIST.app_id — NOT NULL
TAGS
- tag_id — int(11) — Primary key — NOT NULL
- tag_name — varchar(255) — NOT NULL
TITLELIST
- app_id — bigint(20) — Primary key — NOT NULL
- name — varchar(255)
- user_tags — text
- price_us — float
- releaseYear — varchar(10)
- userScore — float
- start_date — datetime — NOT NULL
- end_date — datetime — NOT NULL