game

Tables (13)

App

  • app_id — Primary key — NOT NULL
  • name

App_Dev

  • app_dev_id — Primary key — NOT NULL
  • developer_id — Foreign key → Developer.developer_id — NOT NULL
  • Key — Foreign key → Appdetail.app_id — NOT NULL

App_Genre

  • app_genre_id — Primary key — NOT NULL
  • genre_id — Foreign key → Genre.genre_id — NOT NULL
  • Key — Foreign key → Appdetail.app_id — NOT NULL

App_Pub

  • app_pub_id — Primary key — NOT NULL
  • publisher_id — Foreign key → Publisher.publisher_id — NOT NULL
  • Key — Foreign key → Appdetail.app_id — NOT NULL

Appdetail

  • app_id — Primary key — NOT NULL
  • header_url
  • release_date
  • type

DLC

  • dlc_id — Foreign key → App.app_id — NOT NULL
  • app_id (Key) — Foreign key → Appdetail.app_id — NOT NULL

Description

  • app_id — Foreign key → Appdetail.app_id — NOT NULL
  • short_description
  • min_requirement
  • rec_requirement

Developer

  • developer_id — Primary key — NOT NULL
  • name

Genre

  • genre_id (genid) — Primary key — NOT NULL
  • genre

Price

  • price_key — Primary key — NOT NULL
  • date — Primary key — NOT NULL
  • store_id — Foreign key → Store.store_id — NOT NULL
  • Key — Foreign key → Appdetail.app_id — NOT NULL
  • price
  • init_price
  • discount

Publisher

  • publisher_id — Primary key — NOT NULL
  • name

Recommendation

  • app_id — Foreign key → Appdetail.app_id — NOT NULL
  • count

Store

  • store_id — Primary key — NOT NULL
  • store