Manitou-Mail Home

2.  Table: attachment_contents

Contains an entry for each attachment with its decoded content. To be used in conjunction with the attachments table. Identical attachment contents (same fingerprint) are shared between different attachments.

Structure of attachment_contents

attachment_id

integer

Unique internal identifier for the attachment.

REFERENCES attachments

content

oid

A reference to a PostgreSQL binary large object (blob) The actual contents are located in the pg_largeobject table.

fingerprint

text

Base64-encoded SHA1 fingerprint of the contents.