Generated using SQL Data Dictionary demo version.
| |
Column |
Data Type |
Identity |
Nullable |
Default |
| PK |
RecipientID |
int |
X |
|
|
|
FK
|
MessageID |
int |
|
|
|
|
UserID |
int |
|
|
|
|
Read |
bit |
|
|
0 |
|
Archived |
bit |
|
|
0 |
|
EmailSent |
bit |
|
|
0 |
|
EmailSentDate |
datetime |
|
X |
|
|
EmailSchedulerInstance |
uniqueidentifier |
|
X |
|
|
CreatedByUserID |
int |
|
X |
|
|
CreatedOnDate |
datetime |
|
X |
|
|
LastModifiedByUserID |
int |
|
X |
|
|
LastModifiedOnDate |
datetime |
|
X |
|
|
SendToast |
bit |
|
|
0 |
Indexes:
-
PK_CoreMessaging_MessageRecipients
- (Primary Key)
- (Clustered)
-
IX_CoreMessaging_MessageRecipients_UserID
- UserID
- Read
(Descending)
- Archived
References:
Used by:
- Procedure
dbo.CoreMessaging_ConvertLegacyMessages
- Procedure
dbo.CoreMessaging_CountArchivedConversations
- Procedure
dbo.CoreMessaging_CountArchivedMessages
- Procedure
dbo.CoreMessaging_CountArchivedMessagesByConversation
- Procedure
dbo.CoreMessaging_CountNewThreads
- Procedure
dbo.CoreMessaging_CountNotifications
- Procedure
dbo.CoreMessaging_CountSentConversations
- Procedure
dbo.CoreMessaging_CountTotalConversations
- Procedure
dbo.CoreMessaging_CreateMessageRecipientsForRole
- Procedure
dbo.CoreMessaging_CreateMessageReply
- Procedure
dbo.CoreMessaging_DeleteMessageRecipient
- Procedure
dbo.CoreMessaging_DeleteMessageRecipientByMessageAndUser
- Procedure
dbo.CoreMessaging_DeleteUserFromConversation
- Procedure
dbo.CoreMessaging_GetArchiveBox
- Procedure
dbo.CoreMessaging_GetMessageConversations
- Procedure
dbo.CoreMessaging_GetMessageRecipient
- Procedure
dbo.CoreMessaging_GetMessageRecipientsByMessage
- Procedure
dbo.CoreMessaging_GetMessageRecipientsByMessageAndUser
- Procedure
dbo.CoreMessaging_GetMessageRecipientsByUser
- Procedure
dbo.CoreMessaging_GetMessageThread
- Procedure
dbo.CoreMessaging_GetNextMessagesForDigestDispatch
- Procedure
dbo.CoreMessaging_GetNextMessagesForInstantDispatch
- Procedure
dbo.CoreMessaging_GetNotifications
- Procedure
dbo.CoreMessaging_GetSentBox
- Procedure
dbo.CoreMessaging_GetToasts
- Procedure
dbo.CoreMessaging_IsToastPending
- Procedure
dbo.CoreMessaging_MarkMessageAsDispatched
- Procedure
dbo.CoreMessaging_MarkMessageAsSent
- Procedure
dbo.CoreMessaging_MarkReadyForToast
- Procedure
dbo.CoreMessaging_MarkToastSent
- Procedure
dbo.CoreMessaging_SaveMessageRecipient
- Procedure
dbo.CoreMessaging_UpdateMessageArchivedStatus
- Procedure
dbo.CoreMessaging_UpdateMessageReadStatus
- View
- View