Phone_Banking_Responses

Field

Type

Description

Joins

id

primary key (int)

unique id of phone bank response

ㅤ

call_id

foreign_key (int)

unique id of phone bank call this response corresponds to

id in phone_banking_calls table

question_id

foreign_key (int)

unique id of question this response corresponds to

id in phone_banking_questions table

answer_option_id

foreign_key (int)

unique id of answer option selected in this response

id in phone_banking_answer_options table

created_at

timestamp

date&time response was created in Blocks

unique to table

updated_at

timestamp

date&time response was last updated in Blocks

unique to table

open_ended_answer_text

text

text of answer to an open ended question

unique to table