Helpdesk Database Migrations

Audience

Developers, database engineers, DevOps, QA and support.

Summary

The reviewed Helpdesk project contains three migrations, one current model snapshot and one design-time factory.

Reference Content

The initial migration creates the canonical entity storage and explicit ticket child foreign keys. The second evolves attachment metadata toward external document identifiers. The third adds compatibility fields and filtered uniqueness.

Startup applies migrations only in Development when an explicit skip condition is not enabled. No production migration runner or rollback orchestration is verified.

Requires confirmation

Production migration owner, review/backup/rollback procedure, deployment ordering and automatic-development migration policy require confirmation.

Source References

• 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/HelpdeskDbContext.cs
• microservices/src/helpdesk-service/Program.cs

Related Articles

• Database overview
• Schema reference
• Database limitations

See Also

• API documentation
• Technical documentation

Keywords

EF Core migration, model snapshot, design-time factory, startup migration.

Revision Information

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