Skip navigation links
Sakila Sample Database :: 5 Structure :: 5.1 Tables :: 5.1.11 The inventory Table
5.1.12 The language Table »
Section Navigation      [Toggle]

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: The time that the row was created or most recently updated.

Copyright © 2007, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices