Deleted rows are meant to be history no more.. They should not be modified or deleted, so all constraints are valueless in them... ?
Plus, implementing one way in the system is much easier than creating a copy for every audited table??
I am talking about all tables in the DB, not only content or so; also an update history model is also in the same level to think in.
What you think?
If ACS 3 Model for auditing is available, can we check and discuss it?