{"musical": {"columns": [[0, "Musical_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Year", "INT", 0, null, 0], [3, "Award", "TEXT", 0, null, 0], [4, "Category", "TEXT", 0, null, 0], [5, "Nominee", "TEXT", 0, null, 0], [6, "Result", "TEXT", 0, null, 0]], "primary_keys": ["Musical_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Musical_ID"]]], "check_constraints": []}, "actor": {"columns": [[0, "Actor_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Musical_ID", "INT", 0, null, 0], [3, "Character", "TEXT", 0, null, 0], [4, "Duration", "TEXT", 0, null, 0], [5, "age", "INT", 0, null, 0]], "primary_keys": ["Actor_ID"], "foreign_keys": [[0, 0, "actor", "Musical_ID", "Actor_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Actor_ID"]]], "check_constraints": []}}
CREATE TABLE musical (
    Musical_ID INT   PRIMARY KEY,
    Name TEXT,
    Year INT,
    Award TEXT,
    Category TEXT,
    Nominee TEXT,
    Result TEXT,
    UNIQUE (Musical_ID)
);

CREATE TABLE actor (
    Actor_ID INT   PRIMARY KEY,
    Name TEXT,
    Musical_ID INT,
    Character TEXT,
    Duration TEXT,
    age INT,
    UNIQUE (Actor_ID),
    FOREIGN KEY (Musical_ID) REFERENCES actor(Actor_ID)
);