Skip to main content

Performance Database Documentation

Summary​

Complete Draft persistence documentation for the source-backed Performance EF Core model, migrations, tenant filters, transactional outbox, compatibility, and backfill behavior.

Audience​

Backend engineers, database reviewers, architects, QA, support, operations, security reviewers, and product owners responsible for Performance data.

Overview​

Performance has one runtime DbContext, one derived backfill context using the same model, and a design-time factory. The verified model contains eight logical persisted objects, eight logical primary keys, two configured aggregate-child foreign keys, seven owned-value mappings, six query filters, fourteen snapshot indexes, and two migrations.

The database implementation remains Transitional because compatibility/backfill paths coexist with canonical persistence and because production governance, concurrency, retention, and final system-of-record ownership require confirmation.

Documentation map​

Requires confirmation​

Production ownership, migration governance, retention, recovery, tenant access exceptions, concurrency, compatibility retirement, reconciliation sign-off, and final system-of-record status require confirmation.

Source References​

  • microservices/src/performance-service/Infrastructure/PerformanceDbContext.cs
  • microservices/src/performance-service/Infrastructure/Persistence.cs
  • microservices/src/performance-service/Domain/ReviewCycle/ReviewCycle.cs
  • microservices/src/performance-service/Domain/Appraisal/Appraisal.cs
  • microservices/src/performance-service/Infrastructure/Migrations/PerformanceDbContextModelSnapshot.cs
  • microservices/src/performance-service/Backfill
  • microservices/scripts/smoke-performance.ps1

See Also​

Keywords​

  • Performance persistence
  • EF Core
  • Database documentation

Revision Information​

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