steamERD

Tables (8)

Game

  • Key (gameId) — Primary key — NOT NULL
  • Key (paymentId) — Foreign key → Payment.Key — NOT NULL
  • Field (name)
  • Field2 (genre)
  • Field3 (releaseDate)
  • Field (originalPrice)
  • Field (discountPrice)
  • Field (gameDiscription)
  • Field (systemRequirement)
  • Field (rating)
  • Field (languages)

Payment

  • Key (paymentId) — Primary key — NOT NULL
  • Key (id) — Foreign key → User.Key — NOT NULL
  • Field (method)
  • Field (price)
  • Field (date)

Review

  • Key (reviewId) — Primary key — NOT NULL
  • Key (purchasedGameId) — Foreign key → Untitled.Key — NOT NULL
  • Key (gameId) — Foreign key → Untitled.Key — NOT NULL
  • Key (userId) — Foreign key → Untitled.Key — NOT NULL
  • Field3 (date)
  • Field4 (publisher)
  • Field (content)

Untitled (Refund)

  • Key (refundId) — Primary key — NOT NULL
  • Key (paymentId) — Foreign key → Payment.Key — NOT NULL
  • Key (userId) — Foreign key → Payment.Key — NOT NULL
  • Key (purchasedGameId) — Foreign key → Untitled.Key — NOT NULL
  • Key (gameId) — Foreign key → Untitled.Key — NOT NULL
  • Field (method)
  • Field2 (price)
  • Field3 (date)

Untitled (purchasedGame)

  • Key (purchasedGameId) — Primary key — NOT NULL
  • Key (gameId) — Foreign key → Game.Key — NOT NULL
  • Key (userId) — Foreign key → User.Key — NOT NULL
  • Field (name)
  • Field3 (genre)
  • Field (playTime)

Untitled (Like)

  • Key (likeId) — Primary key — NOT NULL
  • Key (userId) — Foreign key → User.Key — NOT NULL
  • Key (gameId) — Foreign key → Game.Key — NOT NULL

Untitled (comment)

  • Key (commentId) — Primary key — NOT NULL
  • Key (reviewId) — Foreign key → Review.Key — NOT NULL
  • Key (gameId) — Foreign key → Review.Key — NOT NULL
  • Field (content)
  • Field2 (publisher)
  • Field3 (date)

User

  • Key (id) — Primary key — NOT NULL
  • Field (pw)
  • Field2 (phoneNumber)
  • Field3 (country)
  • Field (puchase history)
  • Field2 (games)
  • Field (email)