20241116.sql

-- 补充跟进记录列表的客户经理所属部门id
alter table ecw_customer_followup
    add COLUMN  `dept_id` bigint DEFAULT NULL COMMENT '客户经理/跟进业务员所属部门id' after `follow_user_id`;


update `ecw_customer_followup` f left join `system_user` u on f.follow_user_id = u.id set f.dept_id = u.dept_id;