Generate full reference path for each foreign key
Join tables require a surrogate if they are the target of a foreign key