Skip to main content

Workforce Scheduling Database Documentation

Audience​

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

Overview​

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

Summary​

Workforce Scheduling persistence is Transitional across three runtime bounded-context contexts and one specialized backfill context. Attendance Service is the canonical system of record for shifts, effective-dated assignments, weekly-off rules, and attendance policies. Leave Service owns its holiday and weekly-off calendar records. The monolith remains a compatibility source and fallback owner.

Scope and totals​

This set documents four verified DbContext types, 13 logical entities in the authoritative schema reference, three Attendance migrations plus one snapshot, three Leave migrations plus one snapshot, and the absence of a committed monolith migration set in the reviewed source.

Documentation map​

Use database overview, persistence architecture, DbContexts, storage pages for shifts, assignments, weekly offs, holidays, and policies, plus effective dates, tenant isolation, mappings, relationships, indexes and constraints, conversions, queries, transactions, concurrency, compatibility, migrations, seeding, retention, testing, schema reference, limitations, and source map.

Maturity​

Canonical persistence is Foundation/Partial. Compatibility and backfill storage are Transitional. Retention, concurrency strategy, production migration governance, and authoritative weekly-off ownership require confirmation.

Source References​

  • microservices/src/attendance-service/Infrastructure/AttendanceDbContext.cs
  • microservices/src/attendance-service/Infrastructure/Persistence.cs
  • microservices/src/leave-service/Infrastructure/LeaveDbContext.cs
  • Data/AppDbContext.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