steam_tracker

Tables (6)

Account

  • Key (accountId) — Long — Primary key — NOT NULL
  • Field (username) — String
  • Field (password) — String
  • Field (email) — String
  • Field (nickname) — String
  • Field (role) — enum
  • Field (createdAt)
  • Field2 (updatedAt)

Untitled (Game)

  • Key (gameId) — Long — Primary key — NOT NULL
  • Field (appId) — Long
  • Field (name) — String
  • Field (currentPrice) — Integer
  • Field (originalPrice) — Integer
  • Field (discountPercent) — Integer
  • Field (isTracking) — boolaen
  • Field (createdAt)
  • Field2 (updatedAt)

Untitled (PriceHistory)

  • Key (priceHistoryId) — Long — Primary key — NOT NULL
  • Key (appId) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field2 (currentPrice) — Integer
  • Field (discountPercent) — Integer
  • Field (createdAt)
  • Field2 (updatedAt)

Untitled (Wishlist)

  • Key (wishlistId) — Long — Primary key — NOT NULL
  • Key (accountId) — Long — Foreign key → Account.Key — NOT NULL
  • Key (appId) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (lastNotifiedPrice) — Integer
  • Field (lastNotifiedDiscountPercent) — Integer
  • Field (targetType) — Enum
  • Field (targetPrice) — Integer
  • Field (targetDiscountPercent) — Intger
  • Field (createdAt)
  • Field2 (updatedAt)
  • Field (inTargetRange) — boolean
  • Field2 (lastNotifiedValue) — Integer

Untitled (GameGenreMap)

  • Key (gameGenreMapId) — Primary key — NOT NULL
  • Key (appId) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (genreId) — Foreign key → Untitled.Key — NOT NULL

Untitled (Genre)

  • Key (genreId) — Primary key — NOT NULL
  • Field (genreName)