DVD Rental

Tables (4)

Category (category)

  • Category ID (category_id) — INT(10) — Primary key — NOT NULL
  • Name (name) — varchar(25)
  • Last Update (last_update) — timestamp

Film (film)

  • Film ID (film_id) — INT(10) — Primary key — NOT NULL
  • Language ID (language_id) — INT(10)
  • Title (title) — varchar(255)
  • Description (description) — varchar(255)
  • Release Year (release_year) — integer(4)
  • Rental Duration (rental_duration) — integer(4)
  • Rental Rate (rental_rate) — varchar(255)
  • Length (length) — integer(2)
  • Replacement Cost (replacement_cost) — numeric(19, 0)
  • Field3
  • Field4
  • Field5
  • Field7
  • Field8

Film_Category (film_category)

  • File ID (file_id) — INT(10) — Primary key — NOT NULL
  • Category ID (category_id) — INT(10) — Foreign key → Category.Category ID — NOT NULL
  • Last Update (last_update) — timestamp

Inventory (inventory)

  • Inventory ID (inventory_id) — INT(10) — Primary key
  • Film ID (film_id) — INT(10)
  • Last Update (last_update) — timestamp