Twilio Calls

Field

Type

Description

Notes

id

primary key (int)

unique id of call

joins: call_id in phone_verification_responses table, twilio_call_id in phone_verification_calls table

phone_number

integer

phone number dialed

joins: number in quality_control_phone_verification_calls

duration_in_seconds

integer

duration of the call

unique to table

scan_id

foreign key (int)

unique id of voter_registration_scan

joins: id in voter_registration_scans, voter_registration_scan_id in phone_verification_responses table and voter_registration_scan_visual_review_responses table

user_id

foreign key (int)

unique id of user completing call

joins: id in users table, created_by_user_id in shifts table, deliveries table, voter_registration_scan_batches table, canvassers table, locations table, registration_forms table, phone_verification_responses table; reviewed_by_user_id in voter_registration_scans table; user_id in scheduled_exports table

disconnected_at

timestamp

date/time the call is disconnected

unique to table

created_at

timestamp

date/time the call is started

unique to table

updated_at

timestamp

date/time the call record is updated

unique to table