CREATE TABLE Episode
(
    episode_id       TEXT
            primary key,
    series           TEXT,
    season           INTEGER,
    episode          INTEGER,
    number_in_series INTEGER,
    title            TEXT,
    summary          TEXT,
    air_date         DATE,
    episode_image    TEXT,
    rating           REAL,
    votes            INTEGER
);
Episode
CREATE TABLE Keyword
(
    episode_id TEXT,
    keyword    TEXT,
    primary key (episode_id, keyword),
    foreign key (episode_id) references Episode(episode_id)
);
Keyword
CREATE TABLE Person
(
    person_id     TEXT
            primary key,
    name          TEXT,
    birthdate     DATE,
    birth_name    TEXT,
    birth_place   TEXT,
    birth_region  TEXT,
    birth_country TEXT,
    height_meters REAL,
    nickname      TEXT
);
Person
CREATE TABLE Award
(
    award_id       INTEGER
            primary key,
    organization   TEXT,
    year           INTEGER,
    award_category TEXT,
    award          TEXT,
    series         TEXT,
    episode_id     TEXT,
    person_id      TEXT,
    role           TEXT,
    result         TEXT,
    foreign key (episode_id) references Episode(episode_id),
    foreign key (person_id) references Person(person_id)
);
Award
CREATE TABLE Credit
(
    episode_id TEXT,
    person_id  TEXT,
    category   TEXT,
    role       TEXT,
    credited   TEXT,
    primary key (episode_id, person_id),
    foreign key (episode_id) references Episode(episode_id),
    foreign key (person_id) references Person(person_id)
);
Credit
CREATE TABLE Vote
(
    episode_id TEXT,
    stars      INTEGER,
    votes      INTEGER,
    percent    REAL,
    foreign key (episode_id) references Episode(episode_id)
);
Vote
original_column_name,column_name,column_description,data_format,value_description
person_id,person id,the unique identifier for the person,text,
name,,the name of the person,text,
birthdate,birth date,the date the person was born,date,"if null, it means this birthdate of the person is not available"
birth_name,birth name,the name parents gave to the person shortly after birth,text,
birth_place,birth place,the place where a person was born.,text,"commonsense evidence: the birth place info is integrate if birth_name, birth_place, birth_region don't contain null value
the full birth place = birth_country +birth_region +birth_place"
birth_region,birth region,the geographical area describing where a person was born that is larger than the birth place,text,
birth_country,birth country,the name of the country where the person was born,text,"commonsense evidence: can ask questions about its corresponding continent: e.g.: 
USA --> North America"
height_meters,height meters,how tall the person is in meters,real,
nickname,,the nickname the person goes by,text,
Person
original_column_name,column_name,column_description,data_format,value_description
episode_id,episode id,the id of the episode,text,
stars,,a number between 1 and 10 indicating how much the viewer enjoyed the episode,integer,"commonsense evidence: The higher the number, the more the episode was enjoyed"
votes,,"The total number of viewers that gave the specific episode the number of stars indicated in the ""stars"" column",integer,
percent,,"The percent of viewers that gave the specific episode the number of stars indicated in the ""stars"" column",real,
Vote
original_column_name,column_name,column_description,data_format,value_description
episode_id,episode id,the id of the episode,text,
keyword,,the keyword that is relevant for the episode,text,
Keyword
original_column_name,column_name,column_description,data_format,value_description
episode_id,episode id,the id of the episode to which the credit information pertains,text,
person_id,person id,the id of the person to which the credit information pertains,text,
category,,the kind of credit being recognized,text,
role,,the role for which the person is being recognized,text,"If the credit is for an actor, this is the name of the character he or she portrayed (Dan Florek plays Donald Craven). Otherwise, this is the production role (producer, sound editor)."
credited,,whether the credit was displayed in the credits at the end of the episode,text,"commonsense evidence: A person may fill a role in an episode, but not show up in the on-screen credits. In this case, the work is said to be ""uncredited."""
Credit
original_column_name,column_name,column_description,data_format,value_description
episode_id,episode id,the unique identifier of the episode,text,
series,,the name of the series,text,
season,,a number indicating the season of the episode,integer,
episode,,the sequential number of the episode within a specific season,integer,
number_in_series,number in series,the overall sequence number of episode in the entire series,integer,
title,,the title of the episode,text,
summary,,a brief description of what happens in the episode,text,
air_date,air date,the date the episode was initially broadcast in the United States,date,
episode_image,episode image,a link to an image from the episode,text,
rating,,the weighted average of the votes received for the episode,real,commonsense evidence: The higher rating means the episode has more positive viewer comments. 
votes,,the total number of rating votes for the episode,integer,
Episode
original_column_name,column_name,column_description,data_format,value_description
award_id,award id,the unique identifier for the award nomination,integer,
organization,,the name of the organization that grants the award,text,
year,,the year of the nomination for  the award,integer,
award_category,award category,the class of the award,text,
award,,the specific award,text,
series,,the name of the Law & Order series that has been nominated,text,
episode_id,episode id,the id of the episode that has been nominated,text,
person_id,,the id of the person that has been nominated,text,
role,,the role that has been nominated,text,
result,,the nomination result,text,"Nominee / Winner
commonsense evidence: 'Winner' means that the award was actually received. "
Award