ALTER TABLE assignments
  ADD COLUMN assignment_date date DEFAULT NULL AFTER person_id;

UPDATE assignments a
INNER JOIN slots s
  ON s.event_id = a.event_id
 AND s.event_slot_id = a.event_slot_id
SET a.assignment_date = s.slot_date
WHERE a.assignment_date IS NULL
  AND s.slot_date IS NOT NULL;