email_templates


Description

A row in this table represents an email template in your Lever account.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
email_template_id varchar 2147483647 null
account_survey_email_settings.email_template_id account_survey_email_settings_email_template_id_fkeyN

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

name varchar 2147483647 null

The name of this template.

subject varchar 2147483647 null

The subject line of emails produced by this template. May contain template variables.

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

is_deleted bool 1 false

TRUE if the source of data for the current entity has been deleted.

row_updated_at timestamp 29,6 CURRENT_TIMESTAMP

Date this entity was updated in the database. Useful to setup incremental refreshes of the data in your periodic ETL job.

Indexes

Constraint Name Type Sort Column(s)
email_templates_pkey Primary key Asc email_template_id
email_templates_account_id_index Performance Asc account_id

Relationships