account_survey_email_settings


Description

A row in this table represents an email configuration for a specific account survey. Connects to the email template and the event that triggers sending.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
account_survey_email_setting_id varchar 2147483647 null

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

account_survey_id varchar 2147483647 null
account_surveys.account_survey_id account_survey_email_settings_account_survey_id_fkeyN

ID of the survey associated with this record.

survey_trigger_id varchar 2147483647 null
account_survey_triggers.account_survey_trigger_id account_survey_email_settings_survey_trigger_id_fkeyN

ID of the stage that triggers sending the survey

email_template_id varchar 2147483647 null
email_templates.email_template_id account_survey_email_settings_email_template_id_fkeyN

ID of the email template associated with the accounts survey

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)
account_survey_email_settings_pkey Primary key Asc account_survey_email_setting_id
account_survey_email_settings_account_id_index Performance Asc account_id
account_survey_email_settings_account_survey_id_idx Performance Asc account_survey_id
account_survey_email_settings_email_template_id_idx Performance Asc email_template_id
account_survey_email_settings_survey_trigger_id_idx Performance Asc survey_trigger_id

Relationships