table ceps

-- Table: public.ceps

-- DROP TABLE IF EXISTS public.ceps;

CREATE TABLE IF NOT EXISTS public.ceps
(
    cep integer NOT NULL,
    logradouro character varying(255) COLLATE pg_catalog."default",
    complemento character varying(255) COLLATE pg_catalog."default",
    bairro character varying(255) COLLATE pg_catalog."default",
    localidade character varying(255) COLLATE pg_catalog."default",
    uf character varying(255) COLLATE pg_catalog."default",
    unidade character varying(255) COLLATE pg_catalog."default",
    ibge character varying(255) COLLATE pg_catalog."default",
    gia character varying(255) COLLATE pg_catalog."default",
    deleted_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT ceps_cep_unique UNIQUE (cep)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.ceps
    OWNER to postgres;