Game Review
A GameReview is a rating and optional text review left by a player who has purchased a Game. Reviews affect the game's aggregate rating scores.
Properties
| Property | Type | Description |
|---|---|---|
Id | int | Primary key |
GameId | int | FK → Game |
ReviewerId | int | FK → AppUser |
Rating | int | Score from 1 to 5 |
BodyHtml | string? | Optional review text in HTML |
IsAnonymous | bool | Whether the reviewer's name is hidden |
Eligibility
A user can only review a game they have purchased. One review per user per game — submitting again updates the existing review.
Aggregate Impact
When a review is added or updated, the parent Game's aggregates are recalculated:
ReviewCount— total reviewsRecentReviewCount— reviews in the last 30 daysLifetimeRatingAverage— all-time averageRecentRatingAverage— recent average
These aggregates power the store's sorting and filtering.