What is this?

The Review Database is the authoritative store for every review in the Reviews & Ratings domain. The Review APIReview APIService•v1.0.0The public-facing API for product reviews. Accepts review submissions, serves published reviews, and is the entry point ...Publishesreview-submitted, review-flagged +1Subscribessubmit-review, flag-review +2Ownerreviews-platformMapRepoView docs writes new reviews to it, and the Review Moderation WorkerReview Moderation WorkerService•v1.0.0Asynchronous worker that screens submitted reviews for spam, abuse and policy violations, then publishes or rejects them...Publishesreview-published, review-rejectedSubscribesreview-submitted, review-flaggedOwnerreviews-platformMapRepoView docs records each moderation decision against the stored review.

What does it store?

• Reviews — one row per review: product, customer, rating, title, body and lifecycle status (submitted, published, rejected).
• Moderation decisions — the outcome and reason for each moderated review, kept for audit.

Access patterns

• The Review APIReview APIService•v1.0.0The public-facing API for product reviews. Accepts review submissions, serves published reviews, and is the entry point ...Publishesreview-submitted, review-flagged +1Subscribessubmit-review, flag-review +2Ownerreviews-platformMapRepoView docs writes new reviews and reads published reviews.
• The Review Moderation WorkerReview Moderation WorkerService•v1.0.0Asynchronous worker that screens submitted reviews for spam, abuse and policy violations, then publishes or rejects them...Publishesreview-published, review-rejectedSubscribesreview-submitted, review-flaggedOwnerreviews-platformMapRepoView docs reads submitted reviews and writes moderation outcomes.
• The Rating AggregatorRating AggregatorService•v1.0.0Keeps each product's aggregate star rating up to date as reviews are published, and serves it fast from a cache. Publishesrating-updatedSubscribesreview-publishedOwnerreviews-platformMapRepoView docs reads published reviews to recompute aggregates.