Canvassers

Field

Type

Description

Notes

id

primary key (int)

unique canvasser id

joins: canvasser_id in shifts table and deliveries table

first_name

text

first name of canvasser

unique to table

last_name

text

last name of canvasser

unique to table

phone_number

integer

phone number of canvasser

unique to table

notes

text

any notes entered in canvasser profile

unique to table

turf_id

foreign key (int)

unique id of canvasser turf

joins: id in turfs table, turf_id in locations table and users table

created_at

timestamp

date&time canvasser was created

unique to table

updated_at

timestamp

date&time canvasser was last updated

unique to table

created_by_user_id

foreign key (int)

unique id of user that created the canvasser

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

email

text

email address of canvasser

ㅤ

vdrs

jsonb

list of VDRs held by the canvasser (specific to TX)

ㅤ

archived

text

true/false field

ㅤ

turf_id

foreign key (int)

unique id of location turf

joins: id in turfs table; turf_id in users table and canvassers table

category

text

location category - configurable per tenant

ㅤ

delivery_point_barcode

integer

unique id provided by postal service through API connection

ㅤ