Focus: Read status - updates

Unread updates will be styled differently (e.g. bold title) from ones you’ve already read. To do this we need to:

• Store the read status for each update in the DB
• Update the read status when you view an update
• Display this status in project/show, workspace/updates, and update/index pages

Implementation details

We can create a many-to-many table where we insert entries on a new comment / new update. Entries are only deleted if the parent user or update is deleted.

update_id, user_id, read_timestamp

We should also add a last_updated timestamp to updates. This will be only be updated when a new comment is added.

Todo

1. Backend: Add read_status table, and last_updated field to updates table
2. Backend: Update last_updated field when new comment added
3. Backend: Update read_status table when viewing update/:id/show
4. Backend: Return read status data when fetching updates (workspace/focus)
5. Backend: Return read status data when fetching updates (workspace/updates)
6. Backend: Return read status data when fetching updates (project/show page)
7. Backend: Return read status data when fetching updates (update/index)
8. Frontend: Display read status in frontend