Closed bmamlin closed 1 year ago
Current approach allows messages between individuals by creating a row for each message with from/to users.
null
for anyone except admins (admins only see messages directed to them)null
(everyone) do not provide a reply option.null
This approach assumes we don't need the ability for admins to direct messages to a select group of users. This approach also assumes we don't need to know if a broadcast message has been read
On further reflection, we will want individual users to be able to delete (or mark the message read), which would require a separate table to track individual. It will be easier to simply create a new row for each individual message.
The updated approach would be something like:
@bmamlin and @maurya to discuss options