attachment Table (296)
•
Environment: onsite, online
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.