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)