account_surveys


Description

A row in this table represents a survey. Currently this table contains only diversity surveys but it will grow in the future.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
account_survey_id varchar 2147483647 null
account_survey_email_settings.account_survey_id account_survey_email_settings_account_survey_id_fkeyN
account_survey_triggers.account_survey_id account_survey_triggers_account_survey_id_fkeyN
opportunity_progress_events.account_survey_id opportunities_progress_events_account_survey_id_fkeyN
survey_responses.account_survey_id survey_responses_account_survey_id_fkeyN

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

type varchar 2147483647 null
account_survey_type_enum.account_survey_type_id account_surveys_type_enum_fkeyN

Type of account survey

form_template_id varchar 2147483647 null
form_templates.form_template_id account_surveys_form_template_id_fkeyN

ID of form template associated with this entity.

is_enabled bool 1 null

indicates whether or not surveys are enabled.

is_enabled_for_applications bool 1 null

indicates whether or not surveys are sent to applicants

is_enabled_for_email bool 1 null

indicates whether or not surveys are sent to sourced candidates.

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)
account_surveys_pkey Primary key Asc account_survey_id
account_surveys_account_id_index Performance Asc account_id

Relationships