9
votes
3answers
3k views

What is an audit table?

What are audit tables? How are they useful? I came across them reading this article.
27
votes
7answers
689 views

How should deletions be handled in the database?

I'd like to implement an "undelete" feature in a web application such that a user can change her mind and recover a deleted record. Thoughts on how to implement this? Some options I've considered are ...