| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| film_id |
smallint unsigned |
5 |
|
√ |
|
|
|
| title |
varchar |
255 |
|
|
|
|
|
| description |
text |
65535 |
√ |
|
null |
|
|
| release_year |
year |
0 |
√ |
|
null |
|
|
| language_id |
tinyint unsigned |
3 |
|
|
|
|
|
| original_language_id |
tinyint unsigned |
3 |
√ |
|
null |
|
| language.language_id
|
fk_film_language_original R |
|
| 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 |
5 |
√ |
|
G |
|
|
| special_features |
set |
54 |
√ |
|
null |
|
|
| last_update |
timestamp |
19 |
|
|
CURRENT_TIMESTAMP |
|
|
Table contained 951 rows at Thu Aug 12 09:42 MDT 2010
|
