{"film": {"columns": [[0, "Film_ID", "INT", 0, null, 1], [1, "Title", "TEXT", 0, null, 0], [2, "Studio", "TEXT", 0, null, 0], [3, "Director", "TEXT", 0, null, 0], [4, "Gross_in_dollar", "INT", 0, null, 0]], "primary_keys": ["Film_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Film_ID"]]], "check_constraints": []}, "market": {"columns": [[0, "Market_ID", "INT", 0, null, 1], [1, "Country", "TEXT", 0, null, 0], [2, "Number_cities", "INT", 0, null, 0]], "primary_keys": ["Market_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Market_ID"]]], "check_constraints": []}, "film_market_estimation": {"columns": [[0, "Estimation_ID", "INT", 0, null, 1], [1, "Low_Estimate", "REAL", 0, null, 0], [2, "High_Estimate", "REAL", 0, null, 0], [3, "Film_ID", "INT", 0, null, 0], [4, "Type", "TEXT", 0, null, 0], [5, "Market_ID", "INT", 0, null, 0], [6, "Year", "INT", 0, null, 0]], "primary_keys": ["Estimation_ID"], "foreign_keys": [[0, 0, "market", "Market_ID", "Market_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "film", "Film_ID", "Film_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Estimation_ID"]]], "check_constraints": []}}
CREATE TABLE film (
    Film_ID INT   PRIMARY KEY,
    Title TEXT,
    Studio TEXT,
    Director TEXT,
    Gross_in_dollar INT,
    UNIQUE (Film_ID)
);

CREATE TABLE market (
    Market_ID INT   PRIMARY KEY,
    Country TEXT,
    Number_cities INT,
    UNIQUE (Market_ID)
);

CREATE TABLE film_market_estimation (
    Estimation_ID INT   PRIMARY KEY,
    Low_Estimate REAL,
    High_Estimate REAL,
    Film_ID INT,
    Type TEXT,
    Market_ID INT,
    Year INT,
    UNIQUE (Estimation_ID),
    FOREIGN KEY (Market_ID) REFERENCES market(Market_ID),
    FOREIGN KEY (Film_ID) REFERENCES film(Film_ID)
);