w2p

Tables (7)

Untitled (USER_DISLIKE)

  • Key (user_id) — VARCHAR(50) — Foreign key → user_info.Key — NOT NULL
  • Field (category_id) — VARCHAR(50)

Untitled (GAME_SUBGENRE)

  • appId — VARCHAR(300) — Foreign key → game_info.appId — NOT NULL
  • Field (subgenre_id) — VARCHAR(300)

game_info (GAME_INFO)

  • appId — VARCHAR(300) — Primary key — NOT NULL
  • Field

game_rating (GAME_RATING)

  • appId — VARCHAR(300) — Foreign key → game_info.appId — NOT NULL
  • Key (user_id) — VARCHAR(50) — Foreign key → user_info.Key — NOT NULL
  • Field (game_score) — INT
  • Field (rate_date) — DATE

game_recommend (GAME_RECOMMEND)

  • appId — VARCHAR(300) — Foreign key → game_info.appId — NOT NULL
  • Key (user_id) — VARCHAR(50) — Foreign key → user_info.Key — NOT NULL
  • Field (game_recommend) — INT
  • Field (recommend_date) — DATE

type_info (TYPE_INFO)

  • type_id — VARCHAR(20) — Primary key — NOT NULL
  • Field (type_name) — VARCHAR(500)
  • Field (type_img) — VARCHAR(500)
  • Field (type_desc) — VARCHAR(500)
  • Field (type_sub_name) — VARCHAR(500)
  • Field (type_sub_desc) — VARCHAR(500)

user_info (USER_INFO)

  • Key (user_id) — VARCHAR(50) — Primary key — NOT NULL
  • Field (user_name) — VARCHAR(50)
  • Field (user_ip) — VARCHAR(50)
  • Field (user_date) — DATE
  • Field (user_browser) — VARCHAR(50)
  • Field
  • type_id — VARCHAR(20) — Foreign key → type_info.type_id — NOT NULL