Order Item

An OrderItem represents a single Game within an Order. Since a Store Page can bundle multiple games, each game in the bundle becomes a separate order item.

Properties

Property	Type	Description
Id	int	Primary key
OrderId	int	FK → parent Order
GameId	int	FK → the Game being purchased
TitleSnapshot	string	Game title at time of purchase (immutable)
AmountSats	long	Price portion allocated to this item

Relationships

OrderItem (N) ──── (1) Order
OrderItem (N) ──── (1) Game

Notes

• The TitleSnapshot preserves the game title as it was when the order was placed, even if the maker later renames the game.
• When a store page bundles multiple games, each game's share of the total price is recorded in AmountSats.