What would be a good method to handle an audit trail?

You can check this thread.