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
Last activity: Aug 29, 2025, 02:08 AM