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 |