A row in this table represents a response to a survey by a candidate, can be comprised of multiple questions and answers. See survey_response_answers.


Column Type Size Nulls Auto Default Children Parents Comments
survey_response_id varchar 2147483647 null
opportunity_progress_events.survey_response_id opportunities_progress_events_survey_response_id_fkeyN
survey_response_answers.survey_response_id survey_response_answers_survey_response_id_fkeyN
survey_response_tracking.survey_response_id survey_response_tracking_survey_response_id_fkeyN

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

collection_method varchar 2147483647 null

The method by which survey responses are received. e.g. Email etc.

collection_status varchar 2147483647 null

If the survey response has been received

responded_at timestamp 29,6 null

The date and time the survey response was received

delivered_at timestamp 29,6 null

The date and time the survey was sent

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.

opportunity_id varchar 2147483647 null
opportunities.opportunity_id survey_responses_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

account_survey_id varchar 2147483647 null
account_surveys.account_survey_id survey_responses_account_survey_id_fkeyN

ID of the survey associated with this record.


Constraint Name Type Sort Column(s)
survey_responses_pkey Primary key Asc survey_response_id
survey_responses_acc_survey_id_idx Performance Asc account_survey_id
survey_responses_account_id_index Performance Asc account_id
survey_responses_opportunity_id_idx Performance Asc opportunity_id