-- 增加任务记录字段 ALTER TABLE public.task_record ADD remark_content jsonb NULL; COMMENT ON COLUMN public.task_record.remark_content IS '填写反馈进度'; -- 增加任务记录字段 ALTER TABLE public.task_record ADD task_created_by int NOT NULL DEFAULT 0; COMMENT ON COLUMN public.task_record.task_created_by IS '任务的创建来源'; -- 增加任务记录字段 ALTER TABLE public.task_record ADD assist_state int NOT NULL DEFAULT 1; COMMENT ON COLUMN public.task_record.assist_state IS '辅导异常状态'; -- task_record 处理旧数据 WITH t_taff_assess_content AS ( SELECT staff_assess_content.staff_assess_id, staff_assess_content.category, staff_assess_content."name", staff_assess_content.remark FROM task_record JOIN staff_assess_content ON task_record.staff_assess_id = staff_assess_content.staff_assess_id AND staff_assess_content."name" = task_record.task_name WHERE 1 = 1) UPDATE task_record SET remark_content = t_taff_assess_content.remark FROM t_taff_assess_content WHERE task_record.staff_assess_id = t_taff_assess_content.staff_assess_id AND t_taff_assess_content."name" = task_record.task_name;