I&#39;m working on an application where I need to save basically :
<ol>
<li>CreatedBy (FK to the person table)</li>
<li>CreatedDateTime</li>
<li>UpdatedBy (FK to the person table)</li>
<li>UpdatedDateTime</li>
</ol>
Right now I have these fields in all the tables in my database. But I feel like there should be a better way to do this.

I'm working on an application where I need to save basically :

1. **CreatedBy** (FK to the _person_ table)
2. **CreatedDateTime**
3. **UpdatedBy** (FK to the _person_ table)
4. **UpdatedDateTime**

Right now I have these fields in all the tables in my database. But I feel like there should be a better way to do this.


What is the proper way to save audit information in a database

Product

Explore

Company

Blogs

Partner with us

Support

Comparisons

Comparisons