vtorio/prisma/migrations/20260201204034_add_gow_tables/migration.sql

-- CreateTable
CREATE TABLE "siteinfo_leakcomponents" (
    "id" SERIAL NOT NULL,
    "component_id" VARCHAR(1000),
    "component_type_location" VARCHAR(1000),
    "monitoring_method" VARCHAR(1000),
    "opgal_video_id" VARCHAR(1000),
    "successful_repair_date" VARCHAR(1000),
    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updatedAt" TIMESTAMP(3) NOT NULL,

    CONSTRAINT "siteinfo_leakcomponents_pkey" PRIMARY KEY ("id")
);

-- CreateTable
CREATE TABLE "gow_fac_id" (
    "id" SERIAL NOT NULL,
    "import_id" INTEGER NOT NULL,
    "corp_id" VARCHAR(1000),
    "odeq_fac_id" VARCHAR(1000),
    "odeq_facility_name" VARCHAR(1000),
    "corp_id_2" VARCHAR(1000),
    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updatedAt" TIMESTAMP(3) NOT NULL,

    CONSTRAINT "gow_fac_id_pkey" PRIMARY KEY ("id")
);

-- CreateTable
CREATE TABLE "gow_data" (
    "id" SERIAL NOT NULL,
    "import_id" INTEGER NOT NULL,
    "well_name" VARCHAR(1000),
    "month" VARCHAR(1000),
    "corpId" VARCHAR(1000),
    "completion_type" VARCHAR(1000),
    "state" VARCHAR(1000),
    "days_on" VARCHAR(1000),
    "gas_production" VARCHAR(1000),
    "gas_sales" VARCHAR(1000),
    "oil_production" VARCHAR(1000),
    "oil_sales" VARCHAR(1000),
    "water_production" VARCHAR(1000),
    "operator" VARCHAR(1000),
    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updatedAt" TIMESTAMP(3) NOT NULL,

    CONSTRAINT "gow_data_pkey" PRIMARY KEY ("id")
);

-- CreateTable
CREATE TABLE "gow_corp_ref" (
    "id" SERIAL NOT NULL,
    "import_id" INTEGER NOT NULL,
    "well_name" VARCHAR(1000),
    "api_no" VARCHAR(1000),
    "corporate_id" VARCHAR(1000),
    "current_well_status" VARCHAR(1000),
    "county_parish" VARCHAR(1000),
    "state" VARCHAR(1000),
    "area" VARCHAR(1000),
    "completion_date" VARCHAR(1000),
    "pop_first_production" VARCHAR(1000),
    "operator" VARCHAR(1000),
    "abandon_date" VARCHAR(1000),
    "battery" VARCHAR(1000),
    "common_pad_name" VARCHAR(1000),
    "id_well" VARCHAR(1000),
    "lease_id" VARCHAR(1000),
    "latitude" VARCHAR(1000),
    "longitude" VARCHAR(1000),
    "pad_code" VARCHAR(1000),
    "pad_name" VARCHAR(1000),
    "permit_number" VARCHAR(1000),
    "well_sub_status" VARCHAR(1000),
    "shut_in_date" VARCHAR(1000),
    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updatedAt" TIMESTAMP(3) NOT NULL,

    CONSTRAINT "gow_corp_ref_pkey" PRIMARY KEY ("id")
);