{"film": {"columns": [[0, "Film_ID", "INT", 0, null, 1], [1, "Rank_in_series", "INT", 0, null, 0], [2, "Number_in_season", "INT", 0, null, 0], [3, "Title", "TEXT", 0, null, 0], [4, "Directed_by", "TEXT", 0, null, 0], [5, "Original_air_date", "TEXT", 0, null, 0], [6, "Production_code", "TEXT", 0, null, 0]], "primary_keys": ["Film_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Film_ID"]]], "check_constraints": []}, "cinema": {"columns": [[0, "Cinema_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Openning_year", "INT", 0, null, 0], [3, "Capacity", "INT", 0, null, 0], [4, "Location", "TEXT", 0, null, 0]], "primary_keys": ["Cinema_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Cinema_ID"]]], "check_constraints": []}, "schedule": {"columns": [[0, "Cinema_ID", "INT", 0, null, 1], [1, "Film_ID", "INT", 0, null, 2], [2, "Date", "TEXT", 0, null, 0], [3, "Show_times_per_day", "INT", 0, null, 0], [4, "Price", "float", 0, null, 0]], "primary_keys": ["Cinema_ID", "Film_ID"], "foreign_keys": [[0, 0, "cinema", "Cinema_ID", "Cinema_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "film", "Film_ID", "Film_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Cinema_ID"], [1, 1, "Film_ID"]]], "check_constraints": []}}
CREATE TABLE film (
    Film_ID INT   PRIMARY KEY,
    Rank_in_series INT,
    Number_in_season INT,
    Title TEXT,
    Directed_by TEXT,
    Original_air_date TEXT,
    Production_code TEXT,
    UNIQUE (Film_ID)
);

CREATE TABLE cinema (
    Cinema_ID INT   PRIMARY KEY,
    Name TEXT,
    Openning_year INT,
    Capacity INT,
    Location TEXT,
    UNIQUE (Cinema_ID)
);

CREATE TABLE schedule (
    Cinema_ID INT   PRIMARY KEY,
    Film_ID INT   PRIMARY KEY,
    Date TEXT,
    Show_times_per_day INT,
    Price float,
    PRIMARY KEY (Cinema_ID, Film_ID),
    UNIQUE (Cinema_ID, Film_ID),
    FOREIGN KEY (Cinema_ID) REFERENCES cinema(Cinema_ID),
    FOREIGN KEY (Film_ID) REFERENCES film(Film_ID)
);