-- Schema: spider__perpetrator
CREATE SCHEMA IF NOT EXISTS "spider__perpetrator";

-- Table: people
CREATE TABLE "spider__perpetrator"."people" (
    "People_ID" BIGINT NOT NULL,
    "Name" TEXT,
    "Height" DOUBLE PRECISION,
    "Weight" DOUBLE PRECISION,
    "Home Town" TEXT,
    CONSTRAINT "people_pkey" PRIMARY KEY ("People_ID")
);

-- Table: perpetrator
CREATE TABLE "spider__perpetrator"."perpetrator" (
    "Perpetrator_ID" BIGINT NOT NULL,
    "People_ID" BIGINT,
    "Date" TEXT,
    "Year" DOUBLE PRECISION,
    "Location" TEXT,
    "Country" TEXT,
    "Killed" BIGINT,
    "Injured" BIGINT,
    CONSTRAINT "perpetrator_pkey" PRIMARY KEY ("Perpetrator_ID")
);

-- Foreign Keys
ALTER TABLE "spider__perpetrator"."perpetrator" ADD CONSTRAINT "fk_perpetrator_0" FOREIGN KEY ("People_ID") REFERENCES "spider__perpetrator"."people" ("People_ID") ON DELETE NO ACTION ON UPDATE NO ACTION;
