Review Storage

Summary

AppraisalReview child persistence and stage-history behavior.

Audience

Backend engineers, database reviewers, architects, QA, support, operations, security reviewers, and product owners.

Overview

AppraisalReview is a tenant-scoped child entity created by appraisal transitions. It stores a stage, owned reviewer reference, owned bounded evaluation, optional comment category, and completion time.

Confirmed persistence behavior

• The Appraisal relationship is a required configured foreign key with cascade deletion.
• A convention parent-key index and explicit tenant-plus-parent index exist.
• A tenant query filter is configured.
• ReviewerRef and overall evaluation are required owned mappings; reviewer components may be absent.
• Reviews are ordered by completion time in DTO mapping, not by a database ordering constraint.
• No review update/delete endpoint, peer-review entity, calibration entity, or uniqueness-per-stage constraint exists.
• Review text and evaluation values are intentionally excluded.

Classification

Implemented immutable-style child history; broader review models are Not implemented.

Requires confirmation

Stage uniqueness, editing, retention, redaction, reviewer validation, and ordering guarantees require confirmation.

Related Articles

• Performance database documentation
• Performance technical documentation

See Also

• Performance API documentation
• Performance business documentation

Keywords

• Performance persistence
• Review Storage
• Draft database documentation

Source References

• microservices/src/performance-service/Infrastructure/PerformanceDbContext.cs
• microservices/src/performance-service/Domain/Appraisal/Appraisal.cs
• microservices/src/performance-service/Infrastructure/Migrations/PerformanceDbContextModelSnapshot.cs

Revision Information

• Status: Draft
• Last reviewed: 2026-07-16
• Review cycle: Quarterly