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

-- Table: architect
CREATE TABLE "spider__architecture"."architect" (
    "id" TEXT NOT NULL,
    "name" TEXT,
    "nationality" TEXT,
    "gender" TEXT,
    CONSTRAINT "architect_pkey" PRIMARY KEY ("id")
);

-- Table: bridge
CREATE TABLE "spider__architecture"."bridge" (
    "architect_id" BIGINT,
    "id" BIGINT NOT NULL,
    "name" TEXT,
    "location" TEXT,
    "length_meters" DOUBLE PRECISION,
    "length_feet" DOUBLE PRECISION,
    CONSTRAINT "bridge_pkey" PRIMARY KEY ("id")
);

-- Table: mill
CREATE TABLE "spider__architecture"."mill" (
    "architect_id" BIGINT,
    "id" BIGINT NOT NULL,
    "location" TEXT,
    "name" TEXT,
    "type" TEXT,
    "built_year" BIGINT,
    "notes" TEXT,
    CONSTRAINT "mill_pkey" PRIMARY KEY ("id")
);
