I was looking through the documentation and chapter 6 shows a foregin key on the original table but not on the "_AUD" table is that a setting or is it always the case?
It's always this way.
Over _AUD model there could be many objects wirh the same id. That's why the PK is id + revision.
There is not a direct relation between Person and Address, even more, a relation could be resolved with a previous revision for a given object. Envers only generates an insert if an object changed.
Hope it will help.
Retrieving data ...