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.