ticket_attachment table - SuperOffice

ticket_attachment Table (256)

This table connects an attachment to a message. It references the entry in the attachment table, and the message.

Fields

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
attachment_id	The attachment.id this reference is connected to.	FK attachment	Yes
message_id	The message.id this reference is connected to.	FK ej_message	No
content_id	The content_id of this attachment, used for inline images	String(255)	Yes
inline_image	True if this attachment is inlined in the html_body.	Bool	No

Indexes

Fields	Types	Description
attachment_id	FK	Index
message_id	FK	Index

Relationships

Table	Description
attachment	This table contains metadata for attachments. The actual attachments are stored directly on disk, with filenames based on the the primary key for this table.
ej_message	This table contains the messages listed under tickets.

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

attachment table Get Ticket Attachments attachment_location table kb_attachment table s_attachment table

⌘I