Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| film_id | SMALLINT UNSIGNED | 5 | √ | null |
|
|
||||||||
| title | VARCHAR | 128 | null |
|
|
|||||||||
| description | TEXT | 65535 | √ | null |
|
|
||||||||
| release_year | YEAR | 4 | √ | null |
|
|
||||||||
| language_id | TINYINT UNSIGNED | 3 | null |
|
|
|||||||||
| original_language_id | TINYINT UNSIGNED | 3 | √ | null |
|
|
||||||||
| rental_duration | TINYINT UNSIGNED | 3 | 3 |
|
|
|||||||||
| rental_rate | DECIMAL | 4,2 | 4.99 |
|
|
|||||||||
| length | SMALLINT UNSIGNED | 5 | √ | null |
|
|
||||||||
| replacement_cost | DECIMAL | 5,2 | 19.99 |
|
|
|||||||||
| rating | enum('G', 'PG', 'PG-13', 'R', 'NC-17') | 5 | √ | G |
|
|
||||||||
| special_features | set('Trailers', 'Commentaries', 'Deleted Scenes', 'Behind the Scenes') | 54 | √ | null |
|
|
||||||||
| last_update | TIMESTAMP | 26 | CURRENT_TIMESTAMP |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | film_id |
| idx_fk_language_id | Performance | Asc | language_id |
| idx_fk_original_language_id | Performance | Asc | original_language_id |
| idx_title | Performance | Asc | title |