Deliveries

This table displays delivery information such as office id and turn-in location id from the locations table as well as canvasser id from the canvassers table, turn in date and delivery status.

Field	Type	Description	Joins
id	primary key (int)	unique delivery id	delivery_form_exclusions.delivery_id, registration_forms.delivery_id
office_id	foreign key (int)	unique id of turf selected as the office of the delivery	turfs.id
turn_in_location_id	foreign key (int)	unique id of location selected as the turn-in location for the delivery	locations.id
canvasser_id	foreign key (int)	unique canvasser id of the runner assigned to the delivery	canvassers.id
turn_in_date	timestamp	date of delivery	ㅤ
notes	text	notes added to the delivery	ㅤ
created_at	timestamp	date&time the delivery was created	ㅤ
updated_at	timestamp	date&time the delivery was last updated	ㅤ
created_by_user_id	foreign key (int)	unique id of user that created the delivery	users.id
status	integer	numerical representation of delivery stage: 0 - Selection, 1 - Review, 2 - Ready for Delivery, 3 - Delivered	ㅤ
runner_receipt_data	text	receipt data if a delivery receipt has been uploaded. If a receipt has not been uploaded, this field will be NULL	ㅤ
form_filter_registration_date_start	date	start date of delivery filter - eligible forms	ㅤ
form_filter_registration_date_end	date	end date of delivery filter - eligible forms	ㅤ
form_filter_turf_id	integer	id of the turf of the delivery filter	turfs.id
form_filter_counties	jsonb	counties included in the delivery	registration_forms.county
form_filters_no_county	text	true/false field	ㅤ
delivery_method	text	mail/in_person field	ㅤ
form_filter_qc_statuses	jsonb	list of QC statuses for shifts that will be eligible for the delivery	ㅤ

No result found