CREATE TABLE "Episode"
(
    episode_id       TEXT
        constraint Episode_pk
            primary key,
    season           INTEGER,
    episode          INTEGER,
    number_in_series INTEGER,
    title            TEXT,
    summary          TEXT,
    air_date         TEXT,
    episode_image    TEXT,
    rating           REAL,
    votes            INTEGER
);
Episode
CREATE TABLE Person
(
    name          TEXT
        constraint Person_pk
            primary key,
    birthdate     TEXT,
    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,
    person         TEXT,
    role           TEXT,
    episode_id     TEXT,
    season         TEXT,
    song           TEXT,
    result         TEXT,
    foreign key (person) references Person(name),
    foreign key (episode_id) references Episode(episode_id)
);
Award
CREATE TABLE Character_Award
(
    award_id  INTEGER,
    character TEXT,
    foreign key (award_id) references Award(award_id)
);
Character_Award
CREATE TABLE Credit
(
    episode_id TEXT,
    category   TEXT,
    person     TEXT,
    role       TEXT,
    credited   TEXT,
    foreign key (episode_id) references Episode(episode_id),
    foreign key (person) references Person(name)
);
Credit
CREATE TABLE Keyword
(
    episode_id TEXT,
    keyword    TEXT,
    primary key (episode_id, keyword),
    foreign key (episode_id) references Episode(episode_id)
);
Keyword
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
award_id,award id,A unique identifier for the award,integer,
character,,the name of the awarded character,text,
Character_Award
original_column_name,column_name,column_description,data_format,value_description
name,,the name of the crew,text,
birthdate,birth date,the birth date of the crew,text,YYYY-MM-DD
birth_name,birth name,the birth name of the crew,text,
birth_place,birth place,the birth place of the crew,text,
birth_region,birth region,the birth region of the crew,text,
birth_country,birth country,the birth country of the crew,text,
height_meters,height meters,the height of the crew,real,the unit is meter
nickname,,the nickname of the crew,text,
Person
original_column_name,column_name,column_description,data_format,value_description
episode_id,episode id,A unique identifier for episodes,text,
stars,,the star score of the episode,integer,"1-10
commonsense evidence:
Star classification is a type of rating scale. The lowest star is 1 which means the worst, and the highest star is 10 which means the best. "
votes,,the number of votes of the star score,integer,
percent,,the percent of the vote number of the star score,real,"commonsense evidence:
percent = the number of votes for the star / the total amount of votes for all stars "
Vote
original_column_name,column_name,column_description,data_format,value_description
episode_id,episode id,A unique identifier for episodes,text,
keyword,,the keywords of episode,text,
Keyword
original_column_name,column_name,column_description,data_format,value_description
episode_id,episode id,A unique identifier for episodes,text,
category,,the category of the credit,text,
person,,the name of cast and crew members,text,
role,,the role of the person,text,
credited ,,whether the person is credited ,text,"true/ false
commonsense evidence:
 true: The person is included in the credit list
 false: The person isn't included in the credit list"
Credit
original_column_name,column_name,column_description,data_format,value_description
episode_id,episode id,A unique identifier for episodes,text,
season,,the season of the episode,integer,
episode,,the episode number of the episode,integer,
number_in_series,number in series,the number in series,integer,
title,,the title of the episode,text,
summary,,the summary of the episode,text,
air_date,air date,the air date of the episode,text,YYYY-MM-DD
episode_image,episode image,the image of episode,text,
rating,,the rating of episode,real,"0.0 - 10.0
commonsense evidence:
Higher ratings mean higher quality and better response.
 excellent: 7.0 < rating <= 10.0
 average: 5.0 < rating <= 7.0 
 bad: 0.0 < rating <= 5.0
not bad: average, excellent"
votes,,the votes of episode,integer,"commonsense evidence:
Higher votes mean more audience supports (or popular)."
Episode
original_column_name,column_name,column_description,data_format,value_description
award_id,award id,the unique id for the award,integer,
organization,,the organization that holds the award,text,
year,,year of award,integer,
award_category,,the category of the award,text,
award,,the name of the award,text,
person,,the person who gets the award,text,
role,,the role of the honoree,text,
episode_id,episode id,S stands for 'Season' and E stands for 'Episode',text,
season,,the season of the awarded work,text,
song,,the theme song of the awarded work,text,
result,,the final award result,text,"commonsense evidence:
 Nominee: the prospective recipient of the award. The nominee are people who were nominated but didn't win the award. 
 Winner: the people who finally won the award"
Award