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)