hx-admin-server/database/add_fk.sql

select * from hx_employee_occupation heo
where employee_id not in (
    select id from hx_employee
    );

select * from hx_employee_department
where employee_id not in
(
    select id from hx_employee
    );

select * from hx_employee_occupation
where  occupation_id not in
(select id from hx_occupation);

select *
from hx_employee_department where department_id not in
(select id from hx_department);