Sample Header Ad - 728x90

Database layout to keep track of the "freshness" of a column value in a specific row

0 votes
2 answers
137 views
I have a Person with columns like name, address and bio. How do I store data in order to know the "freshness" of these columns? For instance, *"for the Person Y, the name has changed 2 days ago, and the location 2 weeks ago"*. Is this simply a versioning problem?
Person v1 - name: A1, address: B1, bio: C1, updated_at: 4.days.ago
Person v2 - name: A2, address: B1, bio: C1, updated_at: 3.days.ago
Person v3 - name: A2, address: B1, bio: C2, updated_at: 1.days.ago
And after I look trough different versions to find the last one with a different column? Or is there better ways to handle that? Put freshness data in another table? Or even DB? I will normally use MySQL, unless this can be solved by means of another database management system. Regards. ### Additional details Thank you for you comments and answers, but I was forgetting something: Actually, I need to know when the column value was updated, but by who as well. Something like *"updated at XX by User Y"*.
Asked by den (1 rep)
Aug 8, 2019, 01:49 PM
Last activity: Aug 29, 2025, 02:08 AM