added primary key contraint to all relationships. issue is that multiple
key constraints are not working.