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