game - 2022-07-26 08:47:55

Tables (11)

App

  • app_id — Primary key — NOT NULL
  • name
  • header_url
  • release_date
  • type
  • basegame_id — Foreign key → App.app_id — NOT NULL

App_Dev

  • app_dev_id — Primary key — NOT NULL
  • devieloper_id (developer_id) — Foreign key → Developer.devieloper_id — NOT NULL
  • app_id — Foreign key → App.app_id — NOT NULL

App_Genre

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

App_Pub

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

Description

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

Developer

  • devieloper_id (developer_id) — Primary key — NOT NULL
  • name

Genre

  • genre_id — Primary key — NOT NULL
  • genre

Price

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

Publisher

  • publisher_id — Primary key — NOT NULL
  • name

Recommendation

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

Store

  • store_id — Primary key — NOT NULL
  • store