20241116.sql 328 Bytes EditWeb IDE 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;