attachment Table (296)
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
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.
Fields
Name | Description | Type | Null |
---|---|---|---|
id | The primary key (auto-incremented) | PK | |
content_type | The content type for the attachment (e.g. 'applaction/octet-stream' or 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'). | String(255) | ● |
name | The filename for the attachment. | String(255) | ● |
att_size | The size (in bytes) for the attachment. | Int | ● |
auth_key | The key used for authenticating access to this attachment. | String(255) | ● |
charset | The charset if this is a text attachment | String(255) | ● |
dbi_agent_id | Integration agent (eJournal) | FK dbi_agent | |
dbi_key | The primary key for the integrated entry in the external datasource. | String(255) | |
dbi_last_syncronized | Last external syncronization. | DateTime | |
dbi_last_modified | When the entry was last modified. | DateTime | |
attachment_location_id | The id of the attachment_location this attachment is stored in | FK attachment_location | ● |
Indexes
Fields | Types | Description |
---|---|---|
id | PK | Clustered, Unique |
dbi_agent_id | FK | Index |
dbi_key | String(255) | Index |
dbi_last_syncronized | DateTime | Index |
dbi_last_modified | DateTime | Index |
Relationships
Table | Description |
---|---|
attachment_location | A location for storing attachments |
dbi_agent | DBI agent settings |
doc_document | This table contains documents. |
ej_message | This table contains the messages listed under tickets. |
ejpackage | This table stores packages on the system. |
ejuser | This table contains entries for the users of the system. |
external_document | This table stores documents which can be viewed externaly, through the customer module |
kb_attachment | This table connects FAQ entries to attachments. |
reply_template_attachment | This table is used to connect attachments to reply templates (many-to-many). |
s_attachment | A connector between a message and attachments. One message can contain many attachments. |
s_picture_entry | This table describes each picture in the database |
ticket_attachment | This table connects an attachment to a message. It references the entry in the attachment table, and the message. |
Replication Flags
- None
Security Flags
- No access control via user's Role.