{"journal": {"columns": [[0, "Journal_ID", "INT", 0, null, 1], [1, "Date", "TEXT", 0, null, 0], [2, "Theme", "TEXT", 0, null, 0], [3, "Sales", "INT", 0, null, 0]], "primary_keys": ["Journal_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Journal_ID"]]], "check_constraints": []}, "editor": {"columns": [[0, "Editor_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Age", "REAL", 0, null, 0]], "primary_keys": ["Editor_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Editor_ID"]]], "check_constraints": []}, "journal_committee": {"columns": [[0, "Editor_ID", "INT", 0, null, 1], [1, "Journal_ID", "INT", 0, null, 2], [2, "Work_Type", "TEXT", 0, null, 0]], "primary_keys": ["Editor_ID", "Journal_ID"], "foreign_keys": [[0, 0, "journal", "Journal_ID", "Journal_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "editor", "Editor_ID", "Editor_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Editor_ID"], [1, 1, "Journal_ID"]]], "check_constraints": []}}
CREATE TABLE journal (
    Journal_ID INT   PRIMARY KEY,
    Date TEXT,
    Theme TEXT,
    Sales INT,
    UNIQUE (Journal_ID)
);

CREATE TABLE editor (
    Editor_ID INT   PRIMARY KEY,
    Name TEXT,
    Age REAL,
    UNIQUE (Editor_ID)
);

CREATE TABLE journal_committee (
    Editor_ID INT   PRIMARY KEY,
    Journal_ID INT   PRIMARY KEY,
    Work_Type TEXT,
    PRIMARY KEY (Editor_ID, Journal_ID),
    UNIQUE (Editor_ID, Journal_ID),
    FOREIGN KEY (Journal_ID) REFERENCES journal(Journal_ID),
    FOREIGN KEY (Editor_ID) REFERENCES editor(Editor_ID)
);