address table contains address
information for customers, staff, and stores.
address_id: A surrogate primary key
used to uniquely identify each address in the table.
address: The first line of an address.
address2: An optional second line of an
district: The region of an address,
this may be a state, province, prefecture, etc.
city_id: A foreign key pointing to the
postal_code: The postal code or ZIP
code of the address (where applicable).
phone: The telephone number for the
last_update: The time that the row was
created or most recently updated.
location: A Geometry column with a
spatial index on it.
The spatial location column is supported as of MySQL 5.7.5. This column is only added when executing the sakila SQL files against MySQL server 5.7.5 and above. Additionally, "SPATIAL KEY idx_location" is also added.