CREATE TABLE actor
(
    ActorID           INTEGER
        constraint actor_pk
            primary key,
    Name              TEXT,
    "Date of Birth"   DATE,
    "Birth City"      TEXT,
    "Birth Country"   TEXT,
    "Height (Inches)" INTEGER,
    Biography         TEXT,
    Gender            TEXT,
    Ethnicity         TEXT,
    NetWorth          TEXT
);
actor
CREATE TABLE movie
(
    MovieID        INTEGER
        constraint movie_pk
            primary key,
    Title          TEXT,
    "MPAA Rating"  TEXT,
    Budget         INTEGER,
    Gross          INTEGER,
    "Release Date" TEXT,
    Genre          TEXT,
    Runtime        INTEGER,
    Rating         REAL,
    "Rating Count" INTEGER,
    Summary        TEXT
);
movie
CREATE TABLE characters
(
    MovieID          INTEGER,
    ActorID          INTEGER,
    "Character Name" TEXT,
    creditOrder      INTEGER,
    pay              TEXT,
    screentime       TEXT,
    primary key (MovieID, ActorID),
    foreign key (ActorID) references actor(ActorID),
    foreign key (MovieID) references movie(MovieID)
);
characters
original_column_name,column_name,column_description,data_format,value_description
MovieID,movie id,the unique id for the movie,integer,
ActorID,actor id,the unique id for the actor,integer,
Character Name,character name,the name of the character,text,
creditOrder,credit order,order of the character in the credit list ,integer,
pay,,the salary of the character,text,
screentime,,the screentime of the character,text,"commonsense evidence:
Screentime is directly proportional to the importance of the characters. "
characters
original_column_name,column_name,column_description,data_format,value_description
MovieID,movie id,the unique id for the movie,integer,
Title,,the title of the movie,text,
MPAA Rating,motion picture association of america rating,MPAA rating of the movie,text,"commonsense evidence:
MPAA rating is the movie rating for parents to use as a guide to determine the appropriateness of a film's content for children and teenagers. 
 rated G: General audiences  All ages admitted
 rated PG: Parental guidance suggested  Some material may not be suitable for pre-teenagers
 rated R: Restricted  Under 17 requires accompanying parent or adult guardian
 rated X: No one under 17 admitted"
Budget,,the budget of the movie,integer,the unit is dollar
Gross,,the gross of the movie,integer,
Release Date,,release date,text,yyyy-mm-dd
Genre,,the genre of the movie,text,
Runtime,,the runtime of the movie,integer,
Rating,,the rating of the movie,real,"0.0 - 10.0
commonsense evidence:
Higher ratings mean higher quality and better response. "
Rating Count,rating count,the number of the ratings,integer,
Summary,,the summary of the movie,text,
movie
original_column_name,column_name,column_description,data_format,value_description
ActorID,actor id,the unique id for the actor,integer,
Name,,actor's name,text,
Date of Birth,date of birth,actor's birth date,date,
Birth City,birth city,actor's birth city,text,
Birth Country,birth country,actor's birth country,text,
Height (Inches),height inches,actor's height,integer,the unit is inch
Biography,,actor's biography,text,
Gender,,actor's gender,text,
Ethnicity,,actor's ethnicity,text,
NetWorth,,actor's networth,text,"commonsense evidence:
The actor with more networth is richer. "
actor