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