table ceps cepaberto

-- Table: cep.ceps

-- DROP TABLE IF EXISTS cep.ceps;

CREATE TABLE IF NOT EXISTS cep.ceps
(
    cep character varying(8) COLLATE pg_catalog."default",
    logradouro character varying COLLATE pg_catalog."default",
    complemento character varying COLLATE pg_catalog."default",
    bairro character varying COLLATE pg_catalog."default",
    cidade_id integer,
    estado_id integer,
    CONSTRAINT ceps_cidade_id_fkey FOREIGN KEY (cidade_id)
        REFERENCES cep.cidade (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION,
    CONSTRAINT ceps_estado_id_fkey FOREIGN KEY (estado_id)
        REFERENCES cep.estado (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS cep.ceps
    OWNER to postgres;