Petitions_Signatures

Field	Type	Description	Notes
id	primary key (int)	id of petition signature	joins: petition_signature_id in visual_reviews table
line_number	integer	number of the line the petition signature sits on in petition page	unique to table
created_at	timestamp	date&time signature was created	unique to table
updated_at	timestamp	date&time signature was last updated	unique to table
first_name	text	first name of signer	unique to table
middle_name	text	middle name of signer	unique to table
last_name	text	last name of signer	unique to table
address_one	text	address line one of signer	unique to table
address_two	text	address line two of signer	unique to table
city	text	city of signer	unique to table
state	text	state of signer	unique to table
zipcode	integer	zipcode of signer	unique to table
county	text	county of signer	unique to table
phone_number	integer	phone number of signer	unique to table
email	text	email of signer	unique to table
reviewer_id	foreign key (int)	id of user that reviewed this signature in quality control	joins: id in users table
page_id	foreign key (int)	id of petition page this signature is included on	joins: id in petitions_pages
person_id	foreign key (int)	id of person record created from signer information	joins: id in people (Organizing Specific)
visual_review_approved	text	t/f is signature was marked approved in quality control	unique to table
ocr_data	jsonb	data returned from OCR	unique to table

No result found