Skip to main content

Database Overview

Audience​

Developers, QA and support engineers, data reviewers, implementation partners, solution architects, privacy reviewers and security reviewers.

Overview​

Summary​

The lifecycle has no single database or aggregate. Recruitment owns the accepted-offer path; Employee owns the extracted employee aggregate; the compatibility application owns its own workforce, task and exit records; downstream services own local readiness or clearance data.

Scope and counting rule​

This section counts each relevant DbSet once within its runtime context. Objects with similar names in different contexts remain separate because source shows no shared physical model. The inventory includes operational outbox and processed-event ledgers where they protect lifecycle delivery.

Lifecycle view​

Confirmed characteristics​

  • Extracted contexts use EF Core with provider-specific relational configuration, migrations and current snapshots.
  • Recruitment and Employee convert aggregate domain events into outbox messages during a local save.
  • Payroll and Leave maintain local employee projections from integration consumers.
  • The compatibility application uses its own context and schema initializer; it does not share extracted service stores.
  • Exit persistence is currently in the compatibility application, not Employee Service.
  • No source-backed distributed transaction, shared lifecycle unit of work or cross-store reconciliation coordinator was found.

Classification​

The persistence design is Transitional. Local transaction boundaries are clear, but route-dependent duplicate models and incomplete readiness/clearance integration prevent a single canonical lifecycle view.

Requires confirmation​

Unless explicitly confirmed above, production migration governance, rollback, reconciliation, retention, privacy, performance, concurrency and operational ownership require confirmation.

Source References​

  • microservices/src/recruitment-service/Infrastructure/RecruitmentDbContext.cs
  • microservices/src/employee-service/Infrastructure/EmployeeDbContext.cs
  • Data/AppDbContext.cs

See Also​

Keywords​

  • Onboarding database
  • Offboarding database
  • Lifecycle persistence

Revision Information​

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