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