DB Assignment 2
Tables (9)
discount_infos
- discount_id — INT — Primary key — NOT NULL
- game_id — INT — Foreign key → games.game_id — NOT NULL
- store_id — INT — Foreign key → stores.store_id — NOT NULL
- original_price — INT — NOT NULL
- current_price — INT — NOT NULL
- discount_rate — INT — NOT NULL
- purchase_url — VARCHAR(1000) — NOT NULL
- last_updated — DATETIME
game_genres
- game_id — INT — Foreign key → games.game_id — NOT NULL
- genre_id — INT — Foreign key → genres.genre_id — NOT NULL
game_platforms
- game_id — INT — Foreign key → games.game_id — NOT NULL
- platform_id — INT — Foreign key → platforms.platform_id — NOT NULL
games
- game_id — INT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- developer — VARCHAR(100)
- publisher — VARCHAR(100)
- release_date — DATE
- cover_image_url — VARCHAR(500)
- description — TEXT
genres
- genre_id — INT — Primary key — NOT NULL
- genre_name — VARCHAR(50) — NOT NULL
platforms
- platform_id — INT — Primary key — NOT NULL
- platform_name — VARCHAR(50) — NOT NULL
stores
- store_id — INT — Primary key — NOT NULL
- store_name — VARCHAR(50) — NOT NULL
- store_url — VARCHAR(255)
users
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — DATETIME
wishlists
- wishlist_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- game_id — INT — Foreign key → games.game_id — NOT NULL
- added_at — DATETIME