Phone_Banking_Calls

Field

Type

Description

Joins

id

primary key (int)

unique id of phone banking call

ㅤ

phone_bank_id

foreign key (int)

unique id of phone bank

id in phone_banking_questions

person_id

foreign key (int)

unique id of person being called

id in people table

called_by_user_id

foreign key (int)

unique id of user making the call

id in users table

created_at

timestamp

date&time call was created in Blocks

unique to table

updated_at

timestamp

date&time call was last updated in Blocks

unique to table

participated

text

t/f if the person participated in the phone bank

unique to table

non_participation_reason

text

text of reason why the person did not participate if participated = f

unique to table

round

int

round in which the call was made

unique to table

status

text

active/completed status of the call

unique to table

twilio_call_id

foreign key (int)

unique id of twilio call record

id in twilio_calls table

external

text

t/f if the call was made outside of Blocks

unique to table

notes

text

notes entered by the caller on the call

unique to table