customer table contains a list of all
customer_id: A surrogate 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.
address_id: A foreign key identifying the customer's address in the
active: Indicates whether the customer is an active customer. Setting this to
FALSEserves as an alternative to deleting a customer outright. Most queries should have a
WHERE active = TRUEclause.
create_date: The date the customer was added to the system. This date is automatically set using a trigger during an
last_update: The time that the row was created or most recently updated.