ticket_attachment Table (256)
Some tooltip text!
• 1 minute to read
• 1 minute to read
This table connects an attachment to a message. It references the entry in the attachment table, and the message.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| attachment_id | The attachment.id this reference is connected to. | FK attachment | ● |
| message_id | The message.id this reference is connected to. | FK ej_message | |
| content_id | The content_id of this attachment, used for inline images | String(255) | ● |
| inline_image | True if this attachment is inlined in the html_body. | Bool |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| 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.