I am working on developing an insurance app. We have designed a database table containing all user profile related information, as well as their approvals to different privacy policies.
My question is - which would be a better option to keep track of the history of all changes in the information described above?
Archive table or Audit Log table? or are both needed?
Details
Archive table - a copy of the current table will be created but will contain all the past data. All present data will be in the current table.
Audit Log table - generic table that contain columns that describe which tables and columns from those tables changed and to what values.
Is having one enough? or is it a standard practice to have both an archive table and an audit table to keep track of historical data of user profile related information?
Tried doing some research but all I could find was the archiving of the actual audit log data, not the archiving of the actual data. Makes it seem more confusing.