{"artist": {"columns": [[0, "Artist_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Country", "TEXT", 0, null, 0], [3, "Year_Join", "INT", 0, null, 0], [4, "Age", "INT", 0, null, 0]], "primary_keys": ["Artist_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Artist_ID"]]], "check_constraints": []}, "exhibition": {"columns": [[0, "Exhibition_ID", "INT", 0, null, 1], [1, "Year", "INT", 0, null, 0], [2, "Theme", "TEXT", 0, null, 0], [3, "Artist_ID", "INT", 0, null, 0], [4, "Ticket_Price", "REAL", 0, null, 0]], "primary_keys": ["Exhibition_ID"], "foreign_keys": [[0, 0, "artist", "Artist_ID", "Artist_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Exhibition_ID"]]], "check_constraints": []}, "exhibition_record": {"columns": [[0, "Exhibition_ID", "INT", 0, null, 1], [1, "Date", "TEXT", 0, null, 2], [2, "Attendance", "INT", 0, null, 0]], "primary_keys": ["Exhibition_ID", "Date"], "foreign_keys": [[0, 0, "exhibition", "Exhibition_ID", "Exhibition_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Exhibition_ID"], [1, 1, "Date"]]], "check_constraints": []}}
CREATE TABLE artist (
    Artist_ID INT   PRIMARY KEY,
    Name TEXT,
    Country TEXT,
    Year_Join INT,
    Age INT,
    UNIQUE (Artist_ID)
);

CREATE TABLE exhibition (
    Exhibition_ID INT   PRIMARY KEY,
    Year INT,
    Theme TEXT,
    Artist_ID INT,
    Ticket_Price REAL,
    UNIQUE (Exhibition_ID),
    FOREIGN KEY (Artist_ID) REFERENCES artist(Artist_ID)
);

CREATE TABLE exhibition_record (
    Exhibition_ID INT   PRIMARY KEY,
    Date TEXT   PRIMARY KEY,
    Attendance INT,
    PRIMARY KEY (Exhibition_ID, Date),
    UNIQUE (Exhibition_ID, Date),
    FOREIGN KEY (Exhibition_ID) REFERENCES exhibition(Exhibition_ID)
);