📄 Magento_Email · engine innodb
email_template
Email Templates
Columns (13)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| template_id PK | int unsigned | no | Template ID | |
| template_code | varchar(150) | no | Template Name | |
| template_text | text | no | Template Content | |
| template_styles | text | yes | Templste Styles | |
| template_type | int unsigned | yes | Template Type | |
| template_subject | varchar(200) | no | Template Subject | |
| template_sender_name | varchar(200) | yes | Template Sender Name | |
| template_sender_email | varchar(200) | yes | Template Sender Email | |
| added_at | timestamp | no | CURRENT_TIMESTAMP | Date of Template Creation |
| modified_at | timestamp | no | CURRENT_TIMESTAMP | Date of Template Modification |
| orig_template_code | varchar(200) | yes | Original Template Code | |
| orig_template_variables | text | yes | Original Template Variables | |
| is_legacy | boolean | no | false | Should the template render in legacy mode |
Keys & indexes
Primary key: template_id
Unique
- EMAIL_TEMPLATE_TEMPLATE_CODE (template_code)
Indexes
- EMAIL_TEMPLATE_ADDED_AT (added_at) btree
- EMAIL_TEMPLATE_MODIFIED_AT (modified_at) btree