Addresses

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
ㅤ
line_two
text
line two of address
ㅤ
city
text
city of address
ㅤ
state
text
state of address
ㅤ
zipcode
integer
zipcode of address
ㅤ
created_at
timestamp
date & time the address was created
ㅤ
updated_at
timestamp
date & time the address was last updated
ㅤ
county_id
foreign key (int)
unique id of county
counties.id