20241116.sql 328 Bytes
Newer Older
1 2 3 4 5 6
-- 补充跟进记录列表的客户经理所属部门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;