{"TV_Channel": {"columns": [[0, "id", "TEXT", 0, null, 1], [1, "series_name", "TEXT", 0, null, 0], [2, "Country", "TEXT", 0, null, 0], [3, "Language", "TEXT", 0, null, 0], [4, "Content", "TEXT", 0, null, 0], [5, "Pixel_aspect_ratio_PAR", "TEXT", 0, null, 0], [6, "Hight_definition_TV", "TEXT", 0, null, 0], [7, "Pay_per_view_PPV", "TEXT", 0, null, 0], [8, "Package_Option", "TEXT", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "id"]]], "check_constraints": []}, "TV_series": {"columns": [[0, "id", "REAL", 0, null, 1], [1, "Episode", "TEXT", 0, null, 0], [2, "Air_Date", "TEXT", 0, null, 0], [3, "Rating", "TEXT", 0, null, 0], [4, "Share", "REAL", 0, null, 0], [5, "18_49_Rating_Share", "TEXT", 0, null, 0], [6, "Viewers_m", "TEXT", 0, null, 0], [7, "Weekly_Rank", "REAL", 0, null, 0], [8, "Channel", "TEXT", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [[0, 0, "TV_Channel", "Channel", "id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "id"]]], "check_constraints": []}, "Cartoon": {"columns": [[0, "id", "REAL", 0, null, 1], [1, "Title", "TEXT", 0, null, 0], [2, "Directed_by", "TEXT", 0, null, 0], [3, "Written_by", "TEXT", 0, null, 0], [4, "Original_air_date", "TEXT", 0, null, 0], [5, "Production_code", "REAL", 0, null, 0], [6, "Channel", "TEXT", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [[0, 0, "TV_Channel", "Channel", "id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "id"]]], "check_constraints": []}}
CREATE TABLE TV_Channel (
    id TEXT   PRIMARY KEY,
    series_name TEXT,
    Country TEXT,
    Language TEXT,
    Content TEXT,
    Pixel_aspect_ratio_PAR TEXT,
    Hight_definition_TV TEXT,
    Pay_per_view_PPV TEXT,
    Package_Option TEXT,
    UNIQUE (id)
);

CREATE TABLE TV_series (
    id REAL   PRIMARY KEY,
    Episode TEXT,
    Air_Date TEXT,
    Rating TEXT,
    Share REAL,
    18_49_Rating_Share TEXT,
    Viewers_m TEXT,
    Weekly_Rank REAL,
    Channel TEXT,
    UNIQUE (id),
    FOREIGN KEY (Channel) REFERENCES TV_Channel(id)
);

CREATE TABLE Cartoon (
    id REAL   PRIMARY KEY,
    Title TEXT,
    Directed_by TEXT,
    Written_by TEXT,
    Original_air_date TEXT,
    Production_code REAL,
    Channel TEXT,
    UNIQUE (id),
    FOREIGN KEY (Channel) REFERENCES TV_Channel(id)
);