Skip to main content

Helpdesk Database Documentation

Audience​

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

Overview​

This section documents verified Helpdesk persistence without exposing database/schema names, connection details, SQL or operational migration commands.

Summary​

Helpdesk persistence is Transitional and uses one EF Core runtime context with 13 persisted entity sets. Canonical ticket data, reference data, SLA/escalation state, activity records, processed-event state and transactional outbox messages share the context. Three migrations and one model snapshot are committed.

Only assignment, comment and attachment children have explicit relational foreign keys to Ticket with cascade deletion. Tenant query filters cover tenant-derived entities plus audit/timeline, but do not cover processed-event or outbox records.

Scope and totals​

  • Runtime DbContexts: 1
  • Persisted entity sets in the authoritative schema reference: 13
  • Explicit ticket child relationships: 3
  • Migrations: 3
  • Model snapshots: 1
  • Design-time factories: 1
  • Development seeders: 1
  • Dedicated Helpdesk database tests found: 0

Documentation map​

Start with database overview, persistence architecture, DbContexts and storage pages for tickets, categories, priorities, assignments, comments, attachments, SLAs, escalations, activity, outbox and processed events.

Engineering references cover tenant isolation, mappings, relationships, indexes and constraints, value conversions, queries, transactions, concurrency, compatibility, migrations, development seeding, retention, testing, the schema reference, limitations and source map.

Requires confirmation​

Production migration governance, retention, backup/recovery, concurrency strategy, outbox isolation and compatibility retirement require confirmation.

Source References​

  • microservices/src/helpdesk-service/Infrastructure/HelpdeskDbContext.cs
  • microservices/src/helpdesk-service/Domain/HelpdeskEntities.cs
  • microservices/src/helpdesk-service/Infrastructure/Persistence.cs
  • microservices/src/helpdesk-service/Api/HelpdeskEndpoints.cs
  • microservices/src/helpdesk-service/Program.cs

See Also​

Keywords​

Helpdesk database, EF Core, ticket persistence, outbox, tenant isolation.

Revision Information​

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