Helpdesk Attachment Storage

Audience

Developers, database engineers, security, QA and support.

Summary

TicketAttachment stores metadata and external document/storage identifiers; file bytes are not canonical relational fields.

Reference Content

The ticket foreign key is explicit and cascades on Ticket deletion. Required metadata includes document/storage identifiers, storage key, filename, hash and uploader; content type and sizes have mapping constraints. Tenant/ticket/creation time is indexed.

Compatibility alias properties for size and storage reference are ignored by EF. CommentId is stored but has no configured relationship. Local deletion does not delete the external document.

Requires confirmation

External referential integrity, orphan cleanup, content retention, comment association and cascade consequences 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
• microservices/src/helpdesk-service/Infrastructure/DocumentServiceClient.cs

Related Articles

• Database overview
• Schema reference
• Database limitations

See Also

• API documentation
• Technical documentation

Keywords

Attachment metadata, document reference, file hash, cascade delete.

Revision Information

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