Table address
This table contains address information for customers, staff, and stores. The table primary key appears as a foreign key in the customer, staff, and store tables.
Schema
This table belongs to schema sakila.
Columns
This table contains 8 columns.
address_id-
smallint·NOT NULLA surrogate primary key used to uniquely identify each address in the table.
address-
character varying(50)·NOT NULLThe first line of an address.
address2-
character varying(50)·NULL::character varyingAn optional second line of an address.
district-
character varying(20)·NOT NULLThe region of an address, this may be a state, province, prefecture, etc.
city_id-
smallint·NOT NULLA foreign key pointing to the city table.
postal_code-
character varying(10)·NULL::character varyingThe postal code or ZIP code of the address (where applicable).
phone-
character varying(20)·NOT NULLThe telephone number for the address.
last_update-
timestamp(0) without time zone·NOT NULL·CURRENT_TIMESTAMPWhen the row was created or most recently updated.
Primary key
This table has a primary key.
address-
address_id
Foreign keys
This table has one foreign key.
fk_address_city-
city_id»sakila.city (city_id)·ON UPDATE CASCADE·ON DELETE RESTRICT
Indices
This table has 2 indices.
address_pkey-
address_id idx_address_fk_city_id-
city_id