Goal Storage

Summary

AppraisalGoal child persistence, ownership, indexing, and integrity boundaries.

Audience

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

Overview

AppraisalGoal is a tenant-scoped child entity with application-assigned identity, required Appraisal parent identity, conceptual goal metadata, owned weight and evaluation values, optional manager feedback, an optional compatibility target date, and creation time.

Confirmed persistence behavior

• The Appraisal relationship is a configured required foreign key with cascade deletion.
• A convention parent-key index and an explicit tenant-plus-parent index exist in the snapshot.
• A tenant query filter is configured on Goal.
• Weightage and both evaluation values are required owned mappings.
• Canonical mutation is controlled by Appraisal; compatibility may overwrite the single mapped goal.
• No goal status, progress, objective hierarchy, uniqueness, or concurrency marker is persisted.
• Actual goal and feedback content is intentionally excluded from this documentation.

Classification

Implemented child storage with Transitional compatibility-only target-date behavior.

Requires confirmation

Goal uniqueness, child limits, update/delete lifecycle, progress storage, and retention require confirmation.

Related Articles

• Performance database documentation
• Performance technical documentation

See Also

• Performance API documentation
• Performance business documentation

Keywords

• Performance persistence
• Goal 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