Added associations between users, assignments, and locations tables