Investigate unread_conversation_count
Opening this to investigate what's lead to the design of unread_conversation_count
that it is a column in the users table and not handled by querying the conversation_participations
table for read = false
. While we may not be exercising this feature very much, it seems like a wrong design.