Skip to main content

Migrations and Snapshots

Audience

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

Reference Content

Summary

The seven extracted contexts contain 19 authored migrations and seven current snapshots. The compatibility context contains neither an authored EF migration nor a snapshot and instead uses a runtime schema initializer.

Inventory

ContextAuthored migrationsSnapshotLifecycle-relevant evolution
Recruitment5YesInitial model, compatibility identifiers, employee linkage, workflow reference, completed offer/joining model
Employee2YesInitial employee model, expanded timeline event fields
Payroll4YesPayroll foundation, calculation/lifecycle fields and approved-expense projection
Attendance3YesAttendance foundation, weekly-off policy and employee assignment reference
Leave3YesLeave foundation, employee synchronization and workflow reference
Asset1YesAsset aggregate, history, evidence and event ledgers
Notification1YesNotification delivery/evidence model
Compatibility0NoRuntime initializer and compatibility adjustments
Total197

Ownership model

Safety

No migration was executed. This documentation intentionally omits database names, connection details, generated operations, rollback commands and physical schema identifiers.

Open migration questions

Deployment ordering, backup/restore checks, rollback policy, zero-downtime compatibility, initializer governance and production approval ownership require confirmation.

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/Migrations/RecruitmentDbContextModelSnapshot.cs
  • microservices/src/employee-service/Infrastructure/Migrations/EmployeeDbContextModelSnapshot.cs
  • Data/DatabaseSchemaInitializer.cs

See Also

Keywords

  • Onboarding database
  • Offboarding database
  • Lifecycle persistence

Revision Information

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