{"perpetrator": {"columns": [[0, "Perpetrator_ID", "INT", 0, null, 1], [1, "People_ID", "INT", 0, null, 0], [2, "Date", "TEXT", 0, null, 0], [3, "Year", "REAL", 0, null, 0], [4, "Location", "TEXT", 0, null, 0], [5, "Country", "TEXT", 0, null, 0], [6, "Killed", "INT", 0, null, 0], [7, "Injured", "INT", 0, null, 0]], "primary_keys": ["Perpetrator_ID"], "foreign_keys": [[0, 0, "people", "People_ID", "People_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Perpetrator_ID"]]], "check_constraints": []}, "people": {"columns": [[0, "People_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Height", "REAL", 0, null, 0], [3, "Weight", "REAL", 0, null, 0], [4, "Home Town", "TEXT", 0, null, 0]], "primary_keys": ["People_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "People_ID"]]], "check_constraints": []}}
CREATE TABLE perpetrator (
    Perpetrator_ID INT   PRIMARY KEY,
    People_ID INT,
    Date TEXT,
    Year REAL,
    Location TEXT,
    Country TEXT,
    Killed INT,
    Injured INT,
    UNIQUE (Perpetrator_ID),
    FOREIGN KEY (People_ID) REFERENCES people(People_ID)
);

CREATE TABLE people (
    People_ID INT   PRIMARY KEY,
    Name TEXT,
    Height REAL,
    Weight REAL,
    Home Town TEXT,
    UNIQUE (People_ID)
);