civicrm_mosaico_template

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

Unique Template ID

title VARCHAR 255 null

Title

base VARCHAR 64 null

Name of the Mosaico base template (e.g. versafix-1)

html LONGTEXT 2147483647 null

Fully renderd HTML

metadata LONGTEXT 2147483647 null

Mosaico metadata (JSON)

content LONGTEXT 2147483647 null

Mosaico content (JSON)

msg_tpl_id INT UNSIGNED 10 null
civicrm_msg_template.id FK_civicrm_mosaico_template_msg_tpl_idN

FK to civicrm_msg_template.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_mosaico_template_msg_tpl_id Performance Asc msg_tpl_id

Relationships