managed foreign keys when deleting a user, now able to assign and remove a user from a system