updated assignment, assignment_types relation to be correct