What is the proper way to save audit information in a database
I'm working on an application where I need to save basically : CreatedBy (FK to the person table) CreatedDateTime UpdatedBy (FK to the person table) UpdatedDateTime Right now I have these fields in all the tables in my database. But I feel like the...