Phone_Banking_Phone_Banks

Field

Type

Description

Joins

id

primary key (int)

unique id of phone bank

ㅤ

name

text

name of phone bank in Blocks

unique to table

script_id

foreign_key (int)

unique id of script being used in the phone bank

id in phone_banking_script table

created_by_user_id

foreign_key (int)

unique id of user who created the phone bank

id in users table

current_round

int

current round number of the phone bank

unique to table

list_id

foreign_key (int)

unique id of list being called in phone bank

id in lists table

created_at

timestamp

date&time phone bank was created in Blocks

unique to table

updated_at

timestamp

date&time phone bank was last updated in Blocks

unique to table

daily_start_time

timestamp

time of day the phone bank will open

unique to table

daily_end_time

timestamp

time of day the phone bank will close

unique to table

start_date

timestamp

start date the phone bank will open

unique to table

end_date

timestamp

end date the phone bank will open

unique to table

description

text

user-entered description of the phone bank

unique to table

min_call_delay_in_hours

int

minimum hours before a person will resurface for a subsequent call

unique to table

turf_id

foreign_key (int)

unique id of turf of people to be called in the phone bank

id in turfs table

call_type

text

internal/external if calls in phone bank will be made within Blocks

unique to table

archived

text

t/f if the phone bank is archived or active

unique to table

time_zone

text

timezone of times and dates in phone bank schedule

unique to table