Visual_Reviews

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

Visual_Reviews


 
Table of the Visual QC responses submitted by quality control staff
 

Field
Type
Description
Notes
id
primary key (int)
id of visual review
unique to table
visual_review_response_id
foreign key (int)
id of visual_review_response
joins: id in visual_review_responses table
created_at
timestamp
date&time this review was created
unique to table
updated_at
timestamp
date&time this review was last updated
unique to table
user_id
foreign key (int)
id of user that created this visual review
joins: id in users table
petition_signature_id
foreign key (int)
id of petition signature that this review applies to
joins: id in petition_signatures table
petition_page_id
foreign key (int)
id of petition page that this review applies to
joins: id in petition_pages table
registration_form_id
foreign key (int)
id of registration form that this review applies to
joins: id in registration_forms table