Helpdesk Category Storage

Audience

Developers, database engineers, QA and support.

Summary

Category is a tenant entity with name, optional description and active flag.

Reference Content

The mapping requires name, limits stored name/description lengths, indexes tenant identity and enforces tenant/name uniqueness. Canonical API creates and lists categories; compatibility writes can create a missing category.

Ticket.CategoryId and SlaPolicy.CategoryId are not configured as relational foreign keys. No update/delete API or cleanup lifecycle is verified.

Requires confirmation

Category retirement, referential integrity, duplicate-error mapping and compatibility taxonomy governance 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

Category storage, tenant uniqueness, reference data.

Revision Information

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