added primarykey to assignment relationship