Helpdesk Escalation Storage

Audience

Developers, database engineers, QA and support.

Summary

TicketEscalation is a tenant entity recording ticket, optional SLA identity, level, reason, string-converted status and escalation time.

Reference Content

Reason is required and length-limited. Tenant/ticket/level is indexed. TicketId and TicketSlaId are not configured as relational foreign keys. Automatic SLA checking prevents a second escalation for a given SLA through a pre-insert query, but no unique database constraint enforces that check.

No cleanup or status-transition persistence workflow beyond writes in endpoint handlers is verified.

Requires confirmation

Escalation uniqueness, referential integrity, status lifecycle, retry history and retention require confirmation.

Source References

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

Related Articles

• Database overview
• Schema reference
• Database limitations

See Also

• API documentation
• Technical documentation

Keywords

Escalation storage, escalation level, SLA identity, status.

Revision Information

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