foreign keys part one round two

add foreign keys that can be added w/o any conflicts and error exposures