To each record, add a field modified, that contains a sequence of user-datetime pairs.
The user should be looked up in the user table, and the nickname should be filled in as name (denormalization).
Weed out entries: for each day before today, retain only the last entries for each person that has an entry on that day.
To each record, add a field modified, that contains a sequence of user-datetime pairs. The user should be looked up in the user table, and the nickname should be filled in as name (denormalization). Weed out entries: for each day before today, retain only the last entries for each person that has an entry on that day.