Locations

This table displays information on every location added to Blocks, regardless of type. You will see location names, addresses, types, registration form counts, notes and creation data.

Field	Type	Description	Joins
id	primary key (int)	unique location id	deliveries.turn_in_location_id, shifts.location_id
name	text	name of location	unique to table
street_address	text	street address of location	unique to table
city	text	city of location	unique to table
state	text	state of location	unique to table
zipcode	integer	zip code of location	unique to table
county	text	county of location	unique to table
latitude	integer	latitude of location	unique to table
longitude	integer	longitude of location	unique to table
created_by_user_id	foreign key (int)	unique user id of user that created the location	users.id
location_type	integer	numerical representation of location_type; 0 - Canvassing, 11 - Delivery, 12 - Organizing	unique to table
notes	text	any notes added to the location	unique to table
created_at	timestamp	date&time the location was created	unique to table
updated_at	timestamp	date&time the location was last updated	unique to table
turf_id	foreign key (int)	unique id of location turf	turfs.id
category	text	location category - configurable per tenant	unique to table
delivery_point_barcode	integer	unique id provided by postal service through API connection	unique to table

No result found