ㅇㄹㄴㄹ

Tables (6)

GAME_REVIEW

  • app_id — bigint(20)
  • 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
  • app_id — bigint(20)
  • 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

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

TAGS

  • tag_id — int(11) — Primary key — NOT NULL
  • tag_name — varchar(255) — NOT NULL

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