ALTER TABLE zip_codes
    ADD CONSTRAINT cep_logradouro_fk FOREIGN KEY ( logradouro_id )
        REFERENCES logradouros ( id );