MySQL :: Sakila Sample Database :: 5.1.14 The rental Table

Sakila Sample Database :: 5 Structure :: 5.1 Tables :: 5.1.14 The rental Table

Section Navigation [Toggle]

5.1 Tables
5.1.1 The actor Table
5.1.2 The address Table
5.1.3 The category Table
5.1.4 The city Table
5.1.5 The country Table
5.1.6 The customer Table
5.1.7 The film Table
5.1.8 The film_actor Table
5.1.9 The film_category Table
5.1.10 The film_text Table
5.1.11 The inventory Table
5.1.12 The language Table
5.1.13 The payment Table
5.1.14 The rental Table
5.1.15 The staff Table
5.1.16 The store Table

5.1.14. The rental Table

The rental table contains one row for each rental of each inventory item with information about who rented what item, when it was rented, and when it was returned.

The rental table refers to the inventory, customer, and staff tables and is referred to by the payment table.

Columns

rental_id: A surrogate primary key that uniquely identifies the rental.
rental_date: The date and time that the item was rented.
inventory_id: The item being rented.
customer_id: The customer renting the item.
return_date: The date and time the item was returned.
staff_id: The staff member who processed the rental.
last_update: The time that the row was created or most recently updated.

Top / Previous / Next / Up / Table of Contents