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

-- Table: climber
CREATE TABLE "spider__climbing"."climber" (
    "Climber_ID" BIGINT NOT NULL,
    "Name" TEXT,
    "Country" TEXT,
    "Time" TEXT,
    "Points" DOUBLE PRECISION,
    "Mountain_ID" BIGINT,
    CONSTRAINT "climber_pkey" PRIMARY KEY ("Climber_ID")
);

-- Table: mountain
CREATE TABLE "spider__climbing"."mountain" (
    "Mountain_ID" BIGINT NOT NULL,
    "Name" TEXT,
    "Height" DOUBLE PRECISION,
    "Prominence" DOUBLE PRECISION,
    "Range" TEXT,
    "Country" TEXT,
    CONSTRAINT "mountain_pkey" PRIMARY KEY ("Mountain_ID")
);

-- Foreign Keys
ALTER TABLE "spider__climbing"."climber" ADD CONSTRAINT "fk_climber_0" FOREIGN KEY ("Mountain_ID") REFERENCES "spider__climbing"."mountain" ("Mountain_ID") ON DELETE NO ACTION ON UPDATE NO ACTION;
