Helpdesk Comment Storage

Audience

Developers, database engineers, security, QA and support.

Summary

TicketComment is a tenant child with author fields, required body and internal-visibility flag.

Reference Content

The explicit ticket foreign key cascades on Ticket deletion. Body is required and length-limited; author email is length-limited. Tenant/ticket/creation time is indexed.

The database stores the internal flag but does not enforce who may create or read internal comments. No edit/delete or retention mechanism is verified.

Requires confirmation

Visibility enforcement, immutability, author referential integrity, redaction 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

Comment storage, internal flag, ticket relationship, author.

Revision Information

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