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