email_cache


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ie_id CHAR 36 null
mbox VARCHAR 60 null
subject VARCHAR 255 null
fromaddr VARCHAR 100 null
toaddr VARCHAR 255 null
senddate DATETIME 19 null
message_id VARCHAR 255 null
mailsize INT UNSIGNED 10 null
imap_uid INT UNSIGNED 10 null
msgno INT UNSIGNED 10 null
recent TINYINT 3 null
flagged TINYINT 3 null
answered TINYINT 3 null
deleted TINYINT 3 null
seen TINYINT 3 null
draft TINYINT 3 null

Indexes

Constraint Name Type Sort Column(s)
idx_mail_date Performance Asc/Asc/Asc ie_id + mbox + senddate
idx_mail_from Performance Asc/Asc/Asc ie_id + mbox + fromaddr
idx_mail_subj Performance Asc subject
idx_mail_to Performance Asc toaddr

Relationships