Do the "_AUD" tables need FOREIGN KEY CONSTRAINTS

[yousif.seedhom]

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?

Thanks

[hernanbolido]

Hi!

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.

Regards. Hernán.