5.1.16 The store Table

The store table lists all stores in the system. All inventory is assigned to specific stores, and staff and customers are assigned a “home store”.

The store table refers to the staff and address tables using foreign keys and is referred to by the staff, customer, and inventory tables.

Columns

• store_id: A surrogate primary key that uniquely identifies the store.

• manager_staff_id: A foreign key identifying the manager of this store.

• address_id: A foreign key identifying the address of this store.

• last_update: When the row was created or most recently updated.