{"event": {"columns": [[0, "Event_ID", "INT", 0, null, 1], [1, "Date", "TEXT", 0, null, 0], [2, "Venue", "TEXT", 0, null, 0], [3, "Name", "TEXT", 0, null, 0], [4, "Event_Attendance", "INT", 0, null, 0]], "primary_keys": ["Event_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Event_ID"]]], "check_constraints": []}, "journalist": {"columns": [[0, "journalist_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Nationality", "TEXT", 0, null, 0], [3, "Age", "TEXT", 0, null, 0], [4, "Years_working", "INT", 0, null, 0]], "primary_keys": ["journalist_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "journalist_ID"]]], "check_constraints": []}, "news_report": {"columns": [[0, "journalist_ID", "INT", 0, null, 1], [1, "Event_ID", "INT", 0, null, 2], [2, "Work_Type", "TEXT", 0, null, 0]], "primary_keys": ["journalist_ID", "Event_ID"], "foreign_keys": [[0, 0, "event", "Event_ID", "Event_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "journalist", "journalist_ID", "journalist_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "journalist_ID"], [1, 1, "Event_ID"]]], "check_constraints": []}}
CREATE TABLE event (
    Event_ID INT   PRIMARY KEY,
    Date TEXT,
    Venue TEXT,
    Name TEXT,
    Event_Attendance INT,
    UNIQUE (Event_ID)
);

CREATE TABLE journalist (
    journalist_ID INT   PRIMARY KEY,
    Name TEXT,
    Nationality TEXT,
    Age TEXT,
    Years_working INT,
    UNIQUE (journalist_ID)
);

CREATE TABLE news_report (
    journalist_ID INT   PRIMARY KEY,
    Event_ID INT   PRIMARY KEY,
    Work_Type TEXT,
    PRIMARY KEY (journalist_ID, Event_ID),
    UNIQUE (journalist_ID, Event_ID),
    FOREIGN KEY (Event_ID) REFERENCES event(Event_ID),
    FOREIGN KEY (journalist_ID) REFERENCES journalist(journalist_ID)
);