Helpdesk Assignment Storage

Audience

Developers, database engineers, QA and support.

Summary

TicketAssignment is a tenant-owned history row related to Ticket through an explicit required foreign key.

Reference Content

Fields include ticket identity, assigned-to user/email, assigning user and optional note plus common tenant/timestamps. Tenant/ticket/creation time is indexed. Ticket deletion cascades to assignment history.

Current assignee also resides on Ticket, so current state and history can diverge if writes bypass the assignment handler. User identifiers have no relational link to Employee persistence.

Requires confirmation

History immutability, current/history reconciliation, employee identity integrity 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

Assignment history, ticket foreign key, cascade delete, assignee.

Revision Information

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