email_log


Description

A record of email messages that are sent in relation to an associated entity, such as a submission.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
log_id BIGINT 19 √ null
email_log_users.email_log_id email_log_users_email_log_id_foreignC
assoc_type BIGINT 19 null
assoc_id BIGINT 19 null
sender_id BIGINT 19 null
date_sent DATETIME 19 null
event_type BIGINT 19 √ NULL
from_address VARCHAR 255 √ NULL
recipients TEXT 65535 √ NULL
cc_recipients TEXT 65535 √ NULL
bcc_recipients TEXT 65535 √ NULL
subject VARCHAR 255 √ NULL
body TEXT 65535 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc log_id
email_log_assoc Performance Asc/Asc assoc_type + assoc_id

Relationships

Close relationships within degrees of separation