Page Comparison

...

How many messages should a user be allowed to send?
- 10/min?
- 1/min?
- 1/sec?
How many recipients can be sent to at once?
- 10?
- 50?
- Infinite?
How should we configure Amazon SES?
- Proposal:
  - Reroute bounce and complaints to SNS
  - Have a worker disable emails to hard-bounced recipients
  - Also flip flags in settings for complaints
  - Store the bounce/complaint in a blob
Should users be notified of bounces?
How should we implement the worker that sends messages?
- Proposal:
  - Add a migratable table with a single column of message IDs
  - Add a worker that periodically polls the table
  - If the table is not empty, process N rows from the top
  - Delete rows once finished processing
Should some messages be stored as templates?
- If we start sending out notifications about Entity changes and the like, most of the contents will be similar except for the ID and some small part of the message body. We could conceivably add a flag to the MessageToUser object that tells the client to fill in a messages according to some simple template. Then we could store the key-values of the template in a blob (perhaps following the same schema as StringAnnotations) along with the message.
What options belong in the settings object?
- Send email when...
  - Update to a favorite-ed entity
  - Team is messaged
  - Message from user
  - Admin sends mail to everyone
- Mark message as read if forwarded to email?
When someone is added to a conversation, should they be allowed to see all previous messages within the conversation? Or should it be the client's job to forward each individual message to the person?

Objects

Name	DBO	Migration	DTO
MessageContent (Immutable after creation)	Primary key: ID Foreign key: CreatedBy (UserGroup) Foreign key: MessageBody (S3 File Handle ID) Etag CreatedOn	Backup via ID Note: Etag is required because MessageStatus is mutable.	Interface ID CreatedBy (principal ID) S3 File Handle ID CreatedOn
MessageToUser (Immutable after creation)	Foreign key: ID (MessageContent) Subject (nullable) Self foreign key: InReplyTo (ID) (nullable) Foreign key: InReplyToRootId Recursive foreign key to primary key	Secondary to MessageContent	Implements MessageContent Subject (string, optional) Set of recipient IDs inReplyTo (optional) inReplyToRoot (optional)
MessageRecipient (Immutable after creation)	Foreign key: ID (MessageContent) Foreign key: Recipient ID (UserGroup)	Secondary to MessageContent
MessageStatus	Foreign key: ID (MessageContent) Foreign key: Recipient ID (UserGroup) States: UNREAD, READ, ARCHIVED	Secondary to MessageContent	ID Recipient State
Comment (Immutable after creation)	Foreign key: ID (MessageContent) Target type (Enum ObjectType) Target ID TBD: references to other Comments in the conversation*	Secondary to MessageContent	Implements MessageContent Target type Target ID
CommentVotes	Primary key: Message ID Up votes Down votes Is-comment-inappropriate votes	TBD	ID Up Down
MessagingSettings	Foreign key: User ID (UserGroup) Etag Blob of settings	TBD	ID Notification settings Blacklist of blocked users
MessageBundle			Bundles the MessageToUser and Message Status
MessageRecipientSet			Set of recipient IDs

...

Versions Compared

Old Version 115

New Version 116

Key

Objects