Helpdesk Database Source Map

Audience

Developers, database engineers, QA, security, support and architects.

This map ties database statements to static repository evidence. It does not prove production configuration or data state.

Topic	Primary source
Entity sets, mappings, filters and factory	HelpdeskDbContext
Fields, value objects and enums	HelpdeskEntities
Query/save patterns	HelpdeskEndpoints
Outbox and activity helpers	Persistence
External attachment boundary	DocumentServiceClient
Compatibility upsert/parity	HelpdeskBackfill
Development examples	DevelopmentSeeder
Startup migration behavior	Program
Initial/evolution history	Three migrations
Current mapping state	Model snapshot

The schema reference is the sole authoritative 13-entity inventory. Migration-generated implementation details are summarized rather than reproduced.

Production provider settings, runtime migration state, operational ownership and external document persistence require confirmation.

microservices/src/helpdesk-service/Infrastructure/HelpdeskDbContext.cs
microservices/src/helpdesk-service/Domain/HelpdeskEntities.cs
microservices/src/helpdesk-service/Api/HelpdeskEndpoints.cs
microservices/src/helpdesk-service/Infrastructure/Persistence.cs
microservices/src/helpdesk-service/Backfill/HelpdeskBackfill.cs
microservices/src/helpdesk-service/Infrastructure/DevelopmentSeeder.cs
microservices/src/helpdesk-service/Program.cs
microservices/src/helpdesk-service/Infrastructure/Migrations/20260708165325_InitialHelpdeskSchema.cs
microservices/src/helpdesk-service/Infrastructure/Migrations/20260709095325_AddHelpdeskDocumentAttachmentReferences.cs
microservices/src/helpdesk-service/Infrastructure/Migrations/20260709105542_AddHelpdeskCompatFields.cs
microservices/src/helpdesk-service/Infrastructure/Migrations/HelpdeskDbContextModelSnapshot.cs
microservices/src/helpdesk-service/Infrastructure/DocumentServiceClient.cs

Database source map, mapping evidence, migration evidence, persistence traceability.