CREATE TABLE public.cli_endereco_poco
(
    filial integer NOT NULL,
    cliente integer NOT NULL,
    sequencia integer NOT NULL,
    diametro_poco character varying(100) COLLATE pg_catalog."default" NOT NULL,
    prof_total character varying COLLATE pg_catalog."default" NOT NULL,
    prof_intalacao_bomba character varying(100) COLLATE pg_catalog."default" NOT NULL,
    tubulacao_recalque character varying(100) COLLATE pg_catalog."default" NOT NULL,
    tubo_monitoramento character varying(100) COLLATE pg_catalog."default" NOT NULL,
    marca_bomba character varying(100) COLLATE pg_catalog."default" NOT NULL,
    modelo_bomba character varying(100) COLLATE pg_catalog."default" NOT NULL,
    potencia_bomba character varying(100) COLLATE pg_catalog."default" NOT NULL,
    energia_bomba character varying(100) COLLATE pg_catalog."default" NOT NULL,
    cabo_eletrico_bomba character varying(100) COLLATE pg_catalog."default" NOT NULL,
    cabo_eletrico_eletrodos character varying(100) COLLATE pg_catalog."default" NOT NULL,
    eletrodos_nivel_superir character varying COLLATE pg_catalog."default" NOT NULL,
    eletrodos_nivel_inferior character varying COLLATE pg_catalog."default" NOT NULL,
    nivel_estatico_bomba character varying COLLATE pg_catalog."default" NOT NULL,
    nivel_dinamico_bomba character varying COLLATE pg_catalog."default" NOT NULL,
    vazao_bomba character varying COLLATE pg_catalog."default" NOT NULL,
    marca_painel character varying COLLATE pg_catalog."default" NOT NULL,
    potencia_painel character varying(100) COLLATE pg_catalog."default" NOT NULL,
    rele_nivel_painel character varying(100) COLLATE pg_catalog."default" NOT NULL,
    rele_falta_fase character varying(100) COLLATE pg_catalog."default" NOT NULL,
    rele_termico_painel character varying(100) COLLATE pg_catalog."default" NOT NULL,
    modelo_rele character varying(100) COLLATE pg_catalog."default" NOT NULL,
    amperagem_rele character varying COLLATE pg_catalog."default" NOT NULL,
    contator character varying COLLATE pg_catalog."default" NOT NULL,
    modelo_contator character varying COLLATE pg_catalog."default" NOT NULL,
    tipo_contator character varying(100) COLLATE pg_catalog."default" NOT NULL,
    nome_poco character varying COLLATE pg_catalog."default" NOT NULL,
    observacao character varying(10000) COLLATE pg_catalog."default" NOT NULL,
    codigo_obra character varying(15) COLLATE pg_catalog."default" NOT NULL,
    codigo_art character varying(15) COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT pk_cli_endereco_poco PRIMARY KEY (filial, cliente, sequencia),
    CONSTRAINT fk_cli_endereco FOREIGN KEY (filial, sequencia, cliente)
        REFERENCES public.cli_endereco (filial, sequencia, cliente) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.cli_endereco_poco
    OWNER to postgres;

COMMENT ON TABLE public.cli_endereco_poco
    IS 'Cadastro do dados tecnicos do poço.';