civicrm_mosaico_template - civicrm Database

Columns

Related columns Constraint Comments

Search:

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.

Showing 1 to 7 of 7 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees