Helpdesk Priority Storage

Audience

Developers, database engineers, QA and support.

Summary

Priority is a tenant entity containing name, string-converted level, rank and active flag.

Reference Content

Tenant/name is unique; tenant/rank is indexed but not unique. Level is stored through an enum-to-string conversion. Canonical and compatibility create paths supply defaults for unknown/missing level and nonpositive rank.

Ticket.PriorityId and SlaPolicy.PriorityId are scalar identifiers without configured relational foreign keys. No update/delete lifecycle is registered.

Requires confirmation

Rank uniqueness/bounds, strict enum validation, priority retirement and referential integrity 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

Priority storage, enum conversion, rank index, tenant uniqueness.

Revision Information

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