{"festival_detail": {"columns": [[0, "Festival_ID", "INT", 0, null, 1], [1, "Festival_Name", "TEXT", 0, null, 0], [2, "Chair_Name", "TEXT", 0, null, 0], [3, "Location", "TEXT", 0, null, 0], [4, "Year", "INT", 0, null, 0], [5, "Num_of_Audience", "INT", 0, null, 0]], "primary_keys": ["Festival_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Festival_ID"]]], "check_constraints": []}, "artwork": {"columns": [[0, "Artwork_ID", "INT", 0, null, 1], [1, "Type", "TEXT", 0, null, 0], [2, "Name", "TEXT", 0, null, 0]], "primary_keys": ["Artwork_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Artwork_ID"]]], "check_constraints": []}, "nomination": {"columns": [[0, "Artwork_ID", "INT", 0, null, 1], [1, "Festival_ID", "INT", 0, null, 2], [2, "Result", "TEXT", 0, null, 0]], "primary_keys": ["Artwork_ID", "Festival_ID"], "foreign_keys": [[0, 0, "festival_detail", "Festival_ID", "Festival_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "artwork", "Artwork_ID", "Artwork_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Artwork_ID"], [1, 1, "Festival_ID"]]], "check_constraints": []}}
CREATE TABLE festival_detail (
    Festival_ID INT   PRIMARY KEY,
    Festival_Name TEXT,
    Chair_Name TEXT,
    Location TEXT,
    Year INT,
    Num_of_Audience INT,
    UNIQUE (Festival_ID)
);

CREATE TABLE artwork (
    Artwork_ID INT   PRIMARY KEY,
    Type TEXT,
    Name TEXT,
    UNIQUE (Artwork_ID)
);

CREATE TABLE nomination (
    Artwork_ID INT   PRIMARY KEY,
    Festival_ID INT   PRIMARY KEY,
    Result TEXT,
    PRIMARY KEY (Artwork_ID, Festival_ID),
    UNIQUE (Artwork_ID, Festival_ID),
    FOREIGN KEY (Festival_ID) REFERENCES festival_detail(Festival_ID),
    FOREIGN KEY (Artwork_ID) REFERENCES artwork(Artwork_ID)
);