Assignment_events table #58
Description
Columns:
assignment_id, old_state, changed_at
This should be updated every time an assignment's state is changed.
Probably refactor existing places where we update the assignment state to use a standalone function since we'll update it pretty often. Helps with code dedup.