Login | Register
The address table contains address information for customers, staff, and stores.
address
The address table primary key appears as a foreign key in the customer, staff, and store tables.
customer
staff
store
address_id: A surrogate primary key used to uniquely identify each address in the table.
address_id
address: The first line of an address.
address2: An optional second line of an address.
address2
district: The region of an address, this may be a state, province, prefecture, etc.
district
city_id: A foreign key pointing to the city table.
city_id
city
postal_code: The postal code or ZIP code of the address (where applicable).
postal_code
phone: The telephone number for the address.
phone
last_update: The time that the row was created or most recently updated.
last_update
© 2013, Oracle Corporation and/or its affiliates
