5.1.11 The inventory Table

The inventory table contains one row for each copy of a given film in a given store.

The inventory table refers to the film and store tables using foreign keys and is referred to by the rental table.

Columns
  • inventory_id: A surrogate primary key used to uniquely identify each item in inventory.

  • film_id: A foreign key pointing to the film this item represents.

  • store_id: A foreign key pointing to the store stocking this item.

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