assignment join table and tests