ㅇㅇ

Tables (6)

GAME_REVIEW

  • app_id — BIGINT — Primary key — NOT NULL
  • review_id — INT — Primary key — NOT NULL
  • review_text — TEXT

REVIEW_TAG

  • app_id — BIGINT — Primary key — NOT NULL
  • review_id — INT — Primary key — NOT NULL
  • game — INT — NOT NULL
  • story — INT — NOT NULL
  • graphics — INT — NOT NULL
  • sound — INT — NOT NULL
  • content — INT — NOT NULL
  • originality — INT — NOT NULL
  • stability — INT — NOT NULL
  • convenience — INT — NOT NULL

SIMILAR_GAMES

  • game_app_id — BIGINT — Primary key — NOT NULL
  • recommended_app_id — BIGINT — Primary key — NOT NULL
  • user_tags — JSON

TAGS

  • tag_id — INT — Primary key
  • tag_name — VARCHAR(255) — NOT NULL

TITLELIST

  • app_id — BIGINT — 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

TOPINDIMOBA_GAME

  • app_id — BIGINT — Primary key — NOT NULL
  • start_date — DATETIME — Primary key — NOT NULL