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

-- Table: body_builder
CREATE TABLE "spider__body_builder"."body_builder" (
    "Body_Builder_ID" BIGINT NOT NULL,
    "People_ID" BIGINT,
    "Snatch" DOUBLE PRECISION,
    "Clean_Jerk" DOUBLE PRECISION,
    "Total" DOUBLE PRECISION,
    CONSTRAINT "body_builder_pkey" PRIMARY KEY ("Body_Builder_ID")
);

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

-- Foreign Keys
ALTER TABLE "spider__body_builder"."body_builder" ADD CONSTRAINT "fk_body_builder_0" FOREIGN KEY ("People_ID") REFERENCES "spider__body_builder"."people" ("People_ID") ON DELETE NO ACTION ON UPDATE NO ACTION;
