• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

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 ●

attachment table relationship diagram

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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top