List view
Voter Registration and Quality Control
Voter Registration and Quality Control
Organizing
Organizing
Petitions and Quality Control
Petitions and Quality Control
Imports
This table displays information on imports of people records into Blocks
Field | Type | Description | Joins |
id | primary key (int) | id of import record | import_id in people.extras |
user_id | foreign key (int) | id of user that created the import | id in users table |
created_at | timestamp | date&time import was created | unique to table |
updated_at | timestamp | date&time import was last updated | unique to table |
status | text | status of import, complete/incomplete | unique to table |
for_phone_bank | text | t/f if import was created for a phone bank | unique to table |
stored_spreadsheet_data | jsonb | data on spreadsheet uploaded to Blocks | unique to table |
mappings | jsonb | mappings of fields in spreadsheet to fields in Blocks | unique to table |
filename | text | name of file uploaded to Blocks | unique to table |
auto_merge_required_fields | jsonb | fields required for auto-merging records | unique to table |