CREATE TABLE district_portal_users
(
    district_id     BIGINT NOT NULL,
    portal_users_id BIGINT NOT NULL
);

ALTER TABLE district_portal_users
    ADD CONSTRAINT fk_disporuse_on_district FOREIGN KEY (district_id) REFERENCES district (id);

ALTER TABLE district_portal_users
    ADD CONSTRAINT fk_disporuse_on_portal_user FOREIGN KEY (portal_users_id) REFERENCES portal_user (id);

ALTER TABLE employee
    DROP COLUMN dtype;