table | column | old type | max value or string length | new type | |
region | id | INT unsigned | 248 | TINYINT unsigned | |
name | VARCHAR(4) | 4 | - | ||
language | id | INT unsigned | 107 | TINYINT unsigned | |
name | VARCHAR(4) | 3 | VARCHAR(3) | ||
t_aka_type | id | INT unsigned | 8 | TINYINT unsigned | |
name | VARCHAR(20) | 11 | VARCHAR(11) | ||
title_type | id | INT unsigned | 11 | TINYINT unsigned | |
name | VARCHAR(45) | 12 | VARCHAR(12) | ||
genre | id | INT unsigned | 28 | TINYINT unsigned | |
name | VARCHAR(45) | 11 | VARCHAR(11) | ||
profession | id | INT unsigned | 45 | TINYINT unsigned | |
name | VARCHAR(45) | 25 | VARCHAR(25) | ||
category | id | INT unsigned | 12 | TINYINT unsigned | |
name | VARCHAR(45) | 19 | VARCHAR(19) | ||
character | id | INT | 2735521 | MEDIUMINT unsigned | |
name | VARCHAR(512) | 459 | VARCHAR(459) | ||
title | id | INT unsigned | 31638619 | - | |
title_type_id | INT unsigned | 11 | TINYINT unsigned | ||
primary_title | VARCHAR(512) | 421 | VARCHAR(421) | ||
original_title | VARCHAR(512) | 421 | VARCHAR(421) | ||
start_year | INT unsigned | 2031 | SMALLINT unsigned | ||
end_year | INT unsigned | 2030 | SMALLINT unsigned | ||
runtime_minutes | INT unsigned | 54321 | SMALLINT unsigned | ||
person | id | INT unsigned | 21954871 | - | |
name | VARCHAR(128) | 105 | VARCHAR(105) | ||
birth_year | INT unsigned | 2023 | SMALLINT unsigned | ||
death_year | INT unsigned | 2024 | SMALLINT unsigned | ||
t_aka | title_id | INT unsigned | - | - | |
title | VARCHAR(1024) | 831 | VARCHAR(831) | ||
region_id | INT unsigned | 248 | TINYINT unsigned | ||
language_id | INT unsigned | 107 | TINYINT unsigned | ||
t_aka_type | INT unsigned | 8 | TINYINT unsigned | ||
attributes | TEXT | 62 | TINYTEXT | ||
ordering | INT unsigned | 251 | TINYINT unsigned | ||
episode | title_id | INT unsigned | 31638616 | - | |
parent_title_id | INT unsigned | 31638505 | - | ||
season | INT unsigned | 2024 | SMALLINT unsigned | ||
episode | INT unsigned | 91334 | MEDIUMINT unsigned | ||
rating | title_id | INT unsigned | 31629568 | - | |
average_rating | REAL | 1 – 10, .1f | FLOAT(3,1) unsigned | ||
num_votes | INT unsigned | 2867985 | MEDIUMINT unsigned | ||
title_crew | title_id | INT unsigned | - | - | |
person_id | INT unsigned | - | - | ||
role | ENUM (3 val.) | - | - | ||
title_ principal | title_id | INT unsigned | - | - | |
person_id | INT unsigned | - | - | ||
ordering | INT unsigned | 10 | TINYINT unsigned | ||
category_id | INT unsigned | 12 | TINYINT unsigned | ||
job | VARCHAR(300) | 286 | TEXT | ||
title_principal_ has_character | title_id | INT unsigned | - | - | |
person_id | INT unsigned | - | - | ||
character_id | INT unsigned | 2735521 | MEDIUMINT unsigned | ||
known_for | person_id | INT unsigned | - | - | |
title_id | INT unsigned | - | - | ||
t_aka_has_type | title_id | INT unsigned | - | - | |
ordering | INT unsigned | 251 | TINYINT unsigned | ||
type_id | INT unsigned | 8 | TINYINT unsigned | ||
in_genre | title_id | INT unsigned | - | - | |
genre_id | INT unsigned | - | - | ||
person_has_ profession | person_id | INT unsigned | - | - | |
profession_id | INT unsigned | 45 | TINYINT unsigned | ||