email_templates_settings


Description

More data about custom email templates, including localized properties such as the subject and body.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
email_template_setting_id BIGINT UNSIGNED 20 null
email_id BIGINT 19 null
email_templates.email_id email_templates_settings_email_idC
locale VARCHAR 14 ''
setting_name VARCHAR 255 null
setting_value MEDIUMTEXT 16777215 NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc email_template_setting_id
email_templates_settings_email_id Performance Asc email_id
email_templates_settings_unique Must be unique Asc/Asc/Asc email_id + locale + setting_name

Relationships