List view
Voter Registration and Quality Control
Voter Registration and Quality Control
Organizing
Organizing
Petitions and Quality Control
Petitions and Quality Control
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 |