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