Table afa757bb.email_cache Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
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 4  √  null
flagged tinyint 4  √  null
answered tinyint 4  √  null
deleted tinyint 4  √  null
seen tinyint 4  √  null
draft tinyint 4  √  null

Analyzed at Thu Jun 08 08:00 UTC 2017

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