1 of 1 people found this helpful
Well, 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.