-- 调整旧数据 WITH t1 AS ( SELECT evaluation_cycle.id AS cycle_id FROM evaluation_cycle WHERE deleted_at IS NOT NULL) UPDATE summary_evaluation SET deleted_at = now() FROM t1 WHERE summary_evaluation.cycle_id = t1.cycle_id