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