Helpdesk Ticket Storage

Audience

Developers, database engineers, QA and support.

Summary

Ticket is a tenant-owned root with canonical and compatibility identity, value-converted number/title, classification identifiers, requester/assignee fields, status, lifecycle timestamps and three explicit child collections.

Reference Content

Tenant plus ticket number is unique. Positive compatibility identity is unique per tenant. Status, requester and assignee have tenant-composite indexes. Description, identity and timestamp nullability follows the entity/mapping. Category and priority identifiers are scalar fields without configured relational foreign keys.

Requires confirmation

Ticket deletion policy, classification referential integrity, concurrency token, archival and compatibility identity lifecycle 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

Ticket storage, lifecycle timestamps, ticket number, compatibility identity.

Revision Information

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