{"workshop": {"columns": [[0, "Workshop_ID", "INT", 0, null, 1], [1, "Date", "TEXT", 0, null, 0], [2, "Venue", "TEXT", 0, null, 0], [3, "Name", "TEXT", 0, null, 0]], "primary_keys": ["Workshop_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Workshop_ID"]]], "check_constraints": []}, "submission": {"columns": [[0, "Submission_ID", "INT", 0, null, 1], [1, "Scores", "REAL", 0, null, 0], [2, "Author", "TEXT", 0, null, 0], [3, "College", "TEXT", 0, null, 0]], "primary_keys": ["Submission_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Submission_ID"]]], "check_constraints": []}, "Acceptance": {"columns": [[0, "Submission_ID", "INT", 0, null, 1], [1, "Workshop_ID", "INT", 0, null, 2], [2, "Result", "TEXT", 0, null, 0]], "primary_keys": ["Submission_ID", "Workshop_ID"], "foreign_keys": [[0, 0, "workshop", "Workshop_ID", "Workshop_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "submission", "Submission_ID", "Submission_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Submission_ID"], [1, 1, "Workshop_ID"]]], "check_constraints": []}}
CREATE TABLE workshop (
    Workshop_ID INT   PRIMARY KEY,
    Date TEXT,
    Venue TEXT,
    Name TEXT,
    UNIQUE (Workshop_ID)
);

CREATE TABLE submission (
    Submission_ID INT   PRIMARY KEY,
    Scores REAL,
    Author TEXT,
    College TEXT,
    UNIQUE (Submission_ID)
);

CREATE TABLE Acceptance (
    Submission_ID INT   PRIMARY KEY,
    Workshop_ID INT   PRIMARY KEY,
    Result TEXT,
    PRIMARY KEY (Submission_ID, Workshop_ID),
    UNIQUE (Submission_ID, Workshop_ID),
    FOREIGN KEY (Workshop_ID) REFERENCES workshop(Workshop_ID),
    FOREIGN KEY (Submission_ID) REFERENCES submission(Submission_ID)
);