| Table Name |
Name |
Data Type |
Primary Key |
Unique |
Required |
Autoincrement |
Charset |
Collation |
Comment |
|
film
|
film_id
|
smallint(5) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
|
film
|
title
|
varchar(255)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
film
|
description
|
text
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
film
|
release_year
|
year(4)
|
|
|
|
|
NULL
|
NULL
|
|
|
film
|
language_id
|
tinyint(3) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
|
film
|
original_language_id
|
tinyint(3) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
|
film
|
rental_duration
|
tinyint(3) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
|
film
|
rental_rate
|
decimal(4,2)
|
|
|
|
|
NULL
|
NULL
|
|
|
film
|
length
|
smallint(5) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
|
film
|
replacement_cost
|
decimal(5,2)
|
|
|
|
|
NULL
|
NULL
|
|
|
film
|
rating
|
enum('G','PG','PG-13','R','NC-17')
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
film
|
special_features
|
set('Trailers','Commentaries','Deleted Scenes','Behind the Scenes')
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
film
|
last_update
|
timestamp
|
|
|
|
|
NULL
|
NULL
|
|