· 3 years ago · May 25, 2022, 08:50 PM
1-- Table: cep.ceps
2
3-- DROP TABLE IF EXISTS cep.ceps;
4
5CREATE TABLE IF NOT EXISTS cep.ceps
6(
7 cep character varying(8) COLLATE pg_catalog."default",
8 logradouro character varying COLLATE pg_catalog."default",
9 complemento character varying COLLATE pg_catalog."default",
10 bairro character varying COLLATE pg_catalog."default",
11 cidade_id integer,
12 estado_id integer,
13 CONSTRAINT ceps_cidade_id_fkey FOREIGN KEY (cidade_id)
14 REFERENCES cep.cidade (id) MATCH SIMPLE
15 ON UPDATE NO ACTION
16 ON DELETE NO ACTION,
17 CONSTRAINT ceps_estado_id_fkey FOREIGN KEY (estado_id)
18 REFERENCES cep.estado (id) MATCH SIMPLE
19 ON UPDATE NO ACTION
20 ON DELETE NO ACTION
21)
22
23TABLESPACE pg_default;
24
25ALTER TABLE IF EXISTS cep.ceps
26 OWNER to postgres;