erd
Tables (6)
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
REVIEW_TAG
- id — INT(11) — Primary key — NOT NULL
- review_id — INT(11) — 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
SIMILAR_GAMES
- base_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
- id — INT(11) — NOT NULL
TAGS
- tag_id — INT(11) — Primary key — NOT NULL
- tag_name — VARCHAR(255) — NOT NULL
- user_tags — TEXT
TITLELIST
- app_id — BIGINT(20) — Primary key — NOT NULL
- start_date — DATETIME — Primary key — NOT NULL
- name — VARCHAR(255)
- user_tags — TEXT
- price_us — FLOAT
- releaseYear — VARCHAR(10)
- userScore — FLOAT
- end_date — DATETIME — NOT NULL
TOPINDIMOBA_GAME
- app_id — BIGINT(20) — Primary key — NOT NULL
- start_date — DATETIME — Primary key — NOT NULL
- name — VARCHAR(255)
- price — FLOAT
- release_date — VARCHAR(50)
- end_date — DATETIME — NOT NULL