account_survey_triggers


Description

A row in this table represents an event that will trigger sending the survey by email.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
account_survey_trigger_id varchar 2147483647 null
account_survey_email_settings.survey_trigger_id account_survey_email_settings_survey_trigger_id_fkeyN

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_triggers_account_survey_id_fkeyN

ID of the survey associated with this record.

type varchar 2147483647 null
created_at timestamp 29,6 null

Date the object referred to in this entity was created.

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.

account_stage_id varchar 2147483647 null
account_stages.account_stage_id account_survey_triggers_account_stage_id_fkeyN

ID of the stage associated with this record.

archive_reason_id varchar 2147483647 null
archive_reasons.archive_reason_id account_survey_triggers_archive_reason_id_fkeyN

ID of the archive reason.

Indexes

Constraint Name Type Sort Column(s)
account_survey_triggers_pkey Primary key Asc account_survey_trigger_id
account_survey_triggers_account_id_index Performance Asc account_id
account_survey_triggers_account_stage_id_idx Performance Asc account_stage_id
account_survey_triggers_archive_reason_id_idx Performance Asc archive_reason_id

Relationships