[FEATURE] Allow for varchar PKs in 1:1 relations

fixes #8279