Addresses

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 address id	people.residential_address_id, people.mailing_address_id, organizations.address_id
line_one	text	line one of address	unique to table
line_two	text	line two of address	unique to table
city	text	city of address	unique to table
state	text	state of address	unique to table
zipcode	integer	zipcode of address	unique to table
created_at	timestamp	date & time the address was created	unique to table
updated_at	timestamp	date & time the address was last updated	unique to table
county	text	name of county of address	unique to table

No result found