| Name | DBO | DTO |
|---|
| | - Primary key: Message ID
- Foreign key: CreatedBy (UserGroup)
- RecipientType (string)
- Recipients (gzip-blob)
- Subject
- S3 File Handle
- CreatedOn
parent  | - ID (derived from ID generator)
- CreatedBy (principal ID) (upon creation filled in for the authenticated user)
- RecipientBundle
- Subject (string, optional)
- S3 File Handle
- CreatedOn
- ReplyTo (optional)
|
| | - Primary key: Thread ID
- Foreign key: Message ID
| |
| | - Foreign key: Thread ID
- Unique key: Object ID, Object type
| |
| | - Primary key: Message ID
- Up votes
- Down votes
| TBD |
| | - Foreign key: Message ID
- Foreign key: Recipient ID (UserGroup)
- States: UNREAD, READ, ARCHIVED
| |
| | - Foreign key: User ID (UserGroup)
- Blob of settings
- Etag
| - ID
- Notification levels
- Update to an owned entity
- Update to some favorite entity
- Team
- Message from user
- Mail to everyone
- Etc...
- Message receipt email (if more than one)
- Auto-mark mail as read if forwarded to email
|
| | | Bundles the Message and Message Status |
| | | - RecipientType
- May be a principal, entity, ...
- Array of IDs
- All IDs must be valid (404 otherwise)
|
