Petition_Packets

 
List view
Voter Registration and Quality Control
Organizing
Petitions and Quality Control
Admin
Phone Banking
 

Petition_Packets


 
Table of the packets of petition pages uploaded to Blocks
 

Field
Type
Description
Notes
id
primary key (int)
id of petition packet
joins: packet_id in petition_pages table
file_locator
jsonb
details of file uploaded to Blocks
unique to table
county
text
county selected for the packet
unique to table
shift_id
foreign key (int)
id of shift the packet was uploaded into
joins: id in shifts table
created_at
timestamp
date&time when the packet was created in Blocks
unique to table
updated_at
timestamp
date&time when the packet was updated in Blocks
unique to table
filename
text
name of file uploaded
unique to table
assignee_id
foreign key (int)
id of user assigned to the packet for quality control
joins: id in users table