Scheduled Exports

Field

Type

Description

Notes

id

primary key (int)

unique scheduled_export id

joins: scheduled_export_id in scheduled_exports_turfs

user_id

foreign key (int)

unique user_id

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, and phone_verification_responses table; reviewed_by_user_id in voter_registration_scans table; user_id in twilio_calls table

table_name

text

name of table being exported

unique to table

attachment_name

text

name of export attachment

unique to table

columns

text

list of columns included in the export

unique to table

format

text

file type of export (csv)

unique to table

recipients

text

email of recipients of export

unique to table

frequency

text

daily/weekly field

unique to table

day_of_the_week

text

day of the week the export is sent

unique to table

hour_of_the_day

integer

hour of the day the export is sent

unique to table

time_zone_identifier

text

timezone of user requesting the export

joins: time_zone in users table

last_processed_at

timestamp

last date and time the export was sent

unique to table

created_at

timestamp

date and time the export was created

unique to table

updated_at

timestamp

date and time the export was last updated

unique to table