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