Skip to main content

Migrations

Audience​

Developers, database engineers, QA engineers, support engineers, security engineers, solution architects, and implementation partners.

Reference Content​

This page records source-verified Workforce Scheduling persistence behavior and boundaries.

Summary​

The reviewed source contains six EF migrations across the two extracted service contexts and two model snapshots.

ContextMigration countScheduling/calendar-specific countSnapshot countDesign-time factory
Attendance321Present
Leave31 initial calendar foundation1Present
Monolith0 committed EF migrations foundNot established0Not found

Attendance history​

One initial migration establishes the Attendance context. A later scheduling foundation migration adds canonical shifts, weekly-off rules, policies/rules, assignments, audit, and timeline support. A subsequent scheduling migration adds the optional related-user field to assignments.

Leave history​

The initial Leave migration includes holiday and weekly-off calendar storage. Later Leave migrations address other Leave features.

Runtime behavior​

Attendance and Leave apply pending migrations at startup unless runtime suppression is enabled. No migration was executed during this documentation work. The monolith uses a custom startup schema initializer rather than a committed EF migration set.

Governance​

Production approval, rollback ownership, forward-only policy, backup prerequisites, and zero-downtime compatibility require confirmation.

Source References​

  • microservices/src/attendance-service/Infrastructure/Migrations/AttendanceDbContextModelSnapshot.cs
  • microservices/src/attendance-service/Infrastructure/Persistence.cs
  • microservices/src/attendance-service/Program.cs
  • microservices/src/leave-service/Infrastructure/Migrations/LeaveDbContextModelSnapshot.cs
  • microservices/src/leave-service/Infrastructure/Persistence.cs
  • microservices/src/leave-service/Program.cs

See Also​

Keywords​

  • Workforce Scheduling database
  • Shift persistence
  • Attendance policy storage

Revision Information​

  • Status: Draft
  • Last reviewed: 2026-07-20
  • Next review: 2026-10-20