Junction schema for ticket and comment attachments.

Links tickets or comments to uploaded files (images, documents, etc.) with ordering and optional captions. An attachment belongs to either a ticket directly OR a comment, but not both.

Fields

• ticket_id - Reference to ticket (if attached to ticket directly)
• comment_id - Reference to comment (if attached to comment)
• file_id - Reference to the uploaded file (PhoenixKit.Storage.File)
• position - Display order (1, 2, 3, etc.)
• caption - Optional caption/alt text

Note: Either ticket_id OR comment_id must be set, but not both.

Examples

# Attachment on ticket itself
%TicketAttachment{
  ticket_id: "018e3c4a-9f6b-7890-abcd-ef1234567890",
  comment_id: nil,
  file_id: "018e3c4a-1234-5678-abcd-ef1234567890",
  position: 1,
  caption: "Screenshot of the error"
}

# Attachment on a comment
%TicketAttachment{
  ticket_id: nil,
  comment_id: "018e3c4a-5678-1234-abcd-ef1234567890",
  file_id: "018e3c4a-abcd-efgh-ijkl-mnopqrstuvwx",
  position: 1,
  caption: nil
}