email_cache

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 10 of 16 entries

Indexes

Search:

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

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation

One