The part_numbers table

The part_numbers table joins bodyparts and messages.

When a message contains a textual messsage and two file attachments, there will be three part_numbers rows specifying which bodyparts have which part numbers in this message. (A single bodypart can be sent as part of many messages, often with different part numbers in each message.)

The bytes and lines numbers are necessary to satisfy IMAP requirements. They contain the number of bytes and lines the relevant bodypart has when encoded as specified by this message's Content-Type and Content-Transfer-Encoding header fields.

create table part_numbers ( -- Grant: select, insert message integer references messages(id) on delete cascade, part text not null, bodypart integer references bodyparts(id), bytes integer, lines integer, primary key (message, part) );

The part_numbers table was introduced in version 0.93.

In case of questions, please write to

Relevant links

About this page

Last modified: 2010-11-19