This content has been marked as final.
Show 1 reply
-
1. Re: Referencing _AUD tables ID's as foreign keys to entities
adamw Aug 9, 2011 2:39 AM (in response to drsaturno)1 of 1 people found this helpfulWell, you could have a foregin key to the revision entity (which has a revision number corresponding to the good Alpha version). Having a foreign key directly to Alpha_AUD can be tricky.
Anyway, I think that you are more looking for a workflow solution (I suppose you can have multi-level acceptance in the future)? Envers isn't really for workflows, just for auditing.
Adam