Hi Guys,

I am still confused on how to create a database with the capability to store history data. I have observed that usual databases have a DateModified column. I want to understand how to have a data history in my database for auditing purposes. Do I need to create a separate table to copy all past data as a history data or archived data.

TransactionTable
Code:
TransactionID   TransactionDate    Items     Amount    DateModified
TransactionTableHistory
Code:
TransactionID    TransactionDate    Items    Amount    DateModified
Thank you for your help.