attachments

Contains one entry for each attachment. The actual attachments contents are stored in a dedicated table: attachment_contents.

> Columns

• attachment_id: integer, primary key
  Unique internal identifier for the attachment.

• mail_id: integer
  The internal unique ID of the mail message to which the attachment belongs.
  Foreign key to mail.mail_id.

• content_type: varchar(300)
  The mime type of the attachment such as 'image/jpeg', 'text/plain', 'message/rfc822'...

• content_size: integer
  The attachment's size in bytes.

• filename: varchar(300)
  The attachment's filename, if present.

• charset: varchar(30)
  The character set for text contents (when content_type starts with 'text/'). Typical values are 'utf-8', 'iso-8859-1', 'us-ascii', ...

• mime_content_id: text [v-0.9.11+]
  A string identifying the MIME part's content_id for the attachment. Other attachments may refer to this ID. For example HTML parts use <img src="cid:content_id_of_part"> to embed an attached picture. The use and syntax of content-ID is described in RFC 2392.

> Size

One row per attachment.