Skip to main content

Database Source Map

Audience​

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

Reference Content​

Summary​

This source map identifies the evidence used for the database section. Paths are repository-relative to the backend source repository and expose no environment or connection details.

Runtime contexts and mappings​

AreaPrimary evidence
Recruitment model, filters, mappings and outbox savemicroservices/src/recruitment-service/Infrastructure/RecruitmentDbContext.cs
Recruitment repository query behaviormicroservices/src/recruitment-service/Infrastructure/Persistence.cs
Recruitment completion transaction sequencemicroservices/src/recruitment-service/Application/Commands/OnboardingCommands.cs
Employee model, filters and outbox savemicroservices/src/employee-service/Infrastructure/EmployeeDbContext.cs
Employee aggregate/statusmicroservices/src/employee-service/Domain/Employees/Employee.cs
Compatibility context and filtersData/AppDbContext.cs
Compatibility schema mechanismData/DatabaseSchemaInitializer.cs
Compatibility onboarding behaviorControllers/RecruitmentController.cs
Exit saves and audit behaviorControllers/HrOperationsController.cs
Payroll model and projection consumermicroservices/src/payroll-service/Infrastructure/PayrollDbContext.cs; microservices/src/payroll-service/Messaging/PayrollReadModelConsumer.cs
Attendance model and employee-profile servicemicroservices/src/attendance-service/Infrastructure/AttendanceDbContext.cs; microservices/src/attendance-service/Application/Services/EmployeeProfileService.cs
Leave model and profile consumermicroservices/src/leave-service/Infrastructure/LeaveDbContext.cs; microservices/src/leave-service/Messaging/EmployeeProfileConsumer.cs
Asset model and clearance querymicroservices/src/asset-service/Infrastructure/AssetDbContext.cs; microservices/src/asset-service/Application/Queries/AssetQueries.cs
Notification model and event resolvermicroservices/src/notification-service/Infrastructure/NotificationDbContext.cs; microservices/src/notification-service/Application/EventNotificationResolver.cs
Gateway persistence absence/route boundarymicroservices/src/gateway-api/Program.cs

Migration and snapshot evidence​

Current snapshots are under each extracted context's Infrastructure/Migrations area. Authored migration files in those same areas establish the 19-migration inventory. The compatibility source has no equivalent migration area or snapshot.

Seeder and test evidence​

Development seeder files exist in Recruitment, Employee, Payroll, Leave and Asset infrastructure. Notification uses microservices/src/notification-service/Seed/DefaultTemplateSeeder.cs. Recruitment and Employee smoke evidence is in microservices/scripts/smoke-recruitment.ps1 and microservices/scripts/smoke-employee.ps1.

Review method​

Evidence was gathered through static source inspection only. No service, database, migration, initializer, seeder, smoke script or external API was executed.

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