email_templates


Description

Custom email templates created by each context, and overrides of the default templates.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
email_id BIGINT 19 null
email_templates_settings.email_id email_templates_settings_email_idC
email_key VARCHAR 255 null

Unique identifier for this email.

context_id BIGINT 19 null
journals.journal_id email_templates_context_id_foreignC
alternate_to VARCHAR 255 NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc email_id
email_templates_alternate_to Performance Asc alternate_to
email_templates_context_id Performance Asc context_id
email_templates_email_key Must be unique Asc/Asc email_key + context_id

Relationships