· 3 years ago · May 25, 2022, 08:50 PM
1-- Table: public.ceps
2
3-- DROP TABLE IF EXISTS public.ceps;
4
5CREATE TABLE IF NOT EXISTS public.ceps
6(
7 cep integer NOT NULL,
8 logradouro character varying(255) COLLATE pg_catalog."default",
9 complemento character varying(255) COLLATE pg_catalog."default",
10 bairro character varying(255) COLLATE pg_catalog."default",
11 localidade character varying(255) COLLATE pg_catalog."default",
12 uf character varying(255) COLLATE pg_catalog."default",
13 unidade character varying(255) COLLATE pg_catalog."default",
14 ibge character varying(255) COLLATE pg_catalog."default",
15 gia character varying(255) COLLATE pg_catalog."default",
16 deleted_at timestamp(0) without time zone,
17 created_at timestamp(0) without time zone,
18 updated_at timestamp(0) without time zone,
19 CONSTRAINT ceps_cep_unique UNIQUE (cep)
20)
21
22TABLESPACE pg_default;
23
24ALTER TABLE IF EXISTS public.ceps
25 OWNER to postgres;