{"conductor": {"columns": [[0, "Conductor_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Age", "INT", 0, null, 0], [3, "Nationality", "TEXT", 0, null, 0], [4, "Year_of_Work", "INT", 0, null, 0]], "primary_keys": ["Conductor_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Conductor_ID"]]], "check_constraints": []}, "orchestra": {"columns": [[0, "Orchestra_ID", "INT", 0, null, 1], [1, "Orchestra", "TEXT", 0, null, 0], [2, "Conductor_ID", "INT", 0, null, 0], [3, "Record_Company", "TEXT", 0, null, 0], [4, "Year_of_Founded", "REAL", 0, null, 0], [5, "Major_Record_Format", "TEXT", 0, null, 0]], "primary_keys": ["Orchestra_ID"], "foreign_keys": [[0, 0, "conductor", "Conductor_ID", "Conductor_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Orchestra_ID"]]], "check_constraints": []}, "performance": {"columns": [[0, "Performance_ID", "INT", 0, null, 1], [1, "Orchestra_ID", "INT", 0, null, 0], [2, "Type", "TEXT", 0, null, 0], [3, "Date", "TEXT", 0, null, 0], [4, "Official_ratings_(millions)", "REAL", 0, null, 0], [5, "Weekly_rank", "TEXT", 0, null, 0], [6, "Share", "TEXT", 0, null, 0]], "primary_keys": ["Performance_ID"], "foreign_keys": [[0, 0, "orchestra", "Orchestra_ID", "Orchestra_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Performance_ID"]]], "check_constraints": []}, "show": {"columns": [[0, "Show_ID", "INT", 0, null, 0], [1, "Performance_ID", "INT", 0, null, 0], [2, "If_first_show", "bool", 0, null, 0], [3, "Result", "TEXT", 0, null, 0], [4, "Attendance", "REAL", 0, null, 0]], "primary_keys": [], "foreign_keys": [[0, 0, "performance", "Performance_ID", "Performance_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [], "check_constraints": []}}
CREATE TABLE conductor (
    Conductor_ID INT   PRIMARY KEY,
    Name TEXT,
    Age INT,
    Nationality TEXT,
    Year_of_Work INT,
    UNIQUE (Conductor_ID)
);

CREATE TABLE orchestra (
    Orchestra_ID INT   PRIMARY KEY,
    Orchestra TEXT,
    Conductor_ID INT,
    Record_Company TEXT,
    Year_of_Founded REAL,
    Major_Record_Format TEXT,
    UNIQUE (Orchestra_ID),
    FOREIGN KEY (Conductor_ID) REFERENCES conductor(Conductor_ID)
);

CREATE TABLE performance (
    Performance_ID INT   PRIMARY KEY,
    Orchestra_ID INT,
    Type TEXT,
    Date TEXT,
    Official_ratings_(millions) REAL,
    Weekly_rank TEXT,
    Share TEXT,
    UNIQUE (Performance_ID),
    FOREIGN KEY (Orchestra_ID) REFERENCES orchestra(Orchestra_ID)
);

CREATE TABLE show (
    Show_ID INT,
    Performance_ID INT,
    If_first_show bool,
    Result TEXT,
    Attendance REAL,
    FOREIGN KEY (Performance_ID) REFERENCES performance(Performance_ID)
);