CREATE TABLE characters
(
    movie_title  TEXT
            primary key,
    release_date TEXT,
    hero         TEXT,
    villian      TEXT,
    song         TEXT,
    foreign key (hero) references "voice-actors"(character)
);
characters
CREATE TABLE director
(
    name     TEXT
            primary key,
    director TEXT,
    foreign key (name) references characters(movie_title)
);
director
CREATE TABLE movies_total_gross
(
    movie_title              TEXT,
    release_date             TEXT,
    genre                    TEXT,
    MPAA_rating              TEXT,
    total_gross              TEXT,
    inflation_adjusted_gross TEXT,
    primary key (movie_title, release_date),
    foreign key (movie_title) references characters(movie_title)
);
movies_total_gross
CREATE TABLE revenue
(
    Year                              INTEGER
            primary key,
    "Studio Entertainment[NI 1]"      REAL,
    "Disney Consumer Products[NI 2]"  REAL,
    "Disney Interactive[NI 3][Rev 1]" INTEGER,
    "Walt Disney Parks and Resorts"   REAL,
    "Disney Media Networks"           TEXT,
    Total                             INTEGER
);
revenue
CREATE TABLE "voice-actors"
(
    character     TEXT
            primary key,
    "voice-actor" TEXT,
    movie         TEXT,
    foreign key (movie) references characters(movie_title)
);
voice-actors
original_column_name,column_name,column_description,data_format,value_description
Year,,The year the movie was released.,integer,
Studio Entertainment[NI 1],,The studio entertainment segment of the Walt Disney Company.,real,
Disney Consumer Products[NI 2],,The consumer products segment of the Walt Disney Company.,real,
Disney Interactive[NI 3][Rev 1],,The interactive segment of the Walt Disney Company. ,integer,
Walt Disney Parks and Resorts,,The parks and resorts segment of the Walt Disney Company.,real,
Disney Media Networks,,The media networks segment of the Walt Disney Company.,text,
Total,,The total box office gross for the movie.,integer,
revenue
original_column_name,column_name,column_description,data_format,value_description
movie_title,movie title,unique title of the movie,text,
release_date,release date,The release date of the movie.,text,
hero,,The main character of the movie. ,text,"commonsense evidence:

round role"
villian,,The villain of the movie.,text,a character whose evil actions or motives are important to the plot. 
song,,A song associated with the movie.,text,
characters
original_column_name,column_name,column_description,data_format,value_description
name,,unique movie name,text,
director,,the name of the director,text,"one director may have multiple movies.

more movies --> this director is more productive"
director
original_column_name,column_name,column_description,data_format,value_description
movie_title,movie title,movie title,text,
release_date,release date,release date,text,
genre,,genre of the movie,text,
MPAA_rating,Motion Picture Association of America rating,Motion Picture Association of America of the disney movie,text,"commonsense evidence:
â¢ G: general audience
â¢ PG: mature audiences or parental guidance suggested
â¢ R: restricted: no children under 17 allowed without parents or adult guardians
â¢ PG-13: PARENTS STRONGLY CAUTIONED. Some material may be inappropriate for children under 13
movies need accompany with parents: PG, PG-13, PG-17;
if ""Not rated"" or null, it means this film can show only gets permissions by theatre management
if the film can show without need of permissions of theatre management, the MPAA_rating should not be ""Not rated"" or null"
total_gross,total gross,The total gross of the movie.,text,"commonsense evidence:
more total_gross--> more popular movie"
inflation_adjusted_gross,inflation adjusted gross,The inflation-adjusted gross of the movie.,text,"commonsense evidence:
estimated inflation rate = inflation_adjusted_gross / total_gross;
the current gross = inflation_adjusted_gross"
movies_total_gross
original_column_name,column_name,column_description,data_format,value_description
character,,The unique name of the character. ,text,
voice-actor,,The name of the voice actor.,text,
movie,,The name of the movie.,text,
voice-actors