The customer table

The customer table contains information about all customers described as follows:

Column	Description
customer_id	A primary key used to uniquely identify each customer in the table.
store_id	A foreign key identifying the customer's "home store". Customers are not limited to renting only from this store, but this is the store they generally shop at.
first_name	The customer's first name.
last_name	The customer's last name.
email	The customer's e-mail address.
address_id	A foreign key identifying the customer's address in the address table.
active	Indicates if the customer is an active customer. Setting this to FALSE serves as a logical deletion of the customer.
create_date	The date when the customer was added to the database.
last_update	The most recent row update. It has not been used in this book.

This information of all the customers is shown in a pictorial format in the following screenshot...