📣 Magento_Newsletter · engine innodb

newsletter_template

Newsletter Template

Neighbourhood (1-hop foreign-key graph — showing 1 of 1)

flowchart LR
  c["newsletter_template"]:::center
  n0["newsletter_queue"]
  click n0 "/schema/table/newsletter_queue"
  c -- template_id --> n0
  click c "/schema/table/newsletter_template"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (1)

newsletter_queue → template_id

Columns (12)

Name	Type	Null	Default	Comment
template_id PK	int unsigned	no		Template ID
template_code	varchar(150)	yes		Template Code
template_text	text	yes		Template Text
template_styles	text	yes		Template Styles
template_type	int unsigned	yes		Template Type
template_subject	varchar(200)	yes		Template Subject
template_sender_name	varchar(200)	yes		Template Sender Name
template_sender_email	varchar(200)	yes		Template Sender Email
template_actual	smallint unsigned	yes	1	Template Actual
added_at	timestamp	yes		Added At
modified_at	timestamp	yes		Modified At
is_legacy	boolean	no	false	Should the template render in legacy mode

Keys & indexes

Primary key: template_id

Indexes

NEWSLETTER_TEMPLATE_TEMPLATE_ACTUAL (template_actual) btree
NEWSLETTER_TEMPLATE_ADDED_AT (added_at) btree
NEWSLETTER_TEMPLATE_MODIFIED_AT (modified_at) btree

Referenced by (1)

newsletter_queue .template_id → .template_id (on delete CASCADE)