Information for the CommunicationRecipient

Columns

• Id (datatype: int) Required Primary Key
• CommunicationId (datatype: int) Required Primary Key
• Status (datatype: int) Required Primary Key
• StatusNote (datatype: nvarchar(max)) Required Primary Key
• AdditionalMergeValuesJson (datatype: nvarchar(max)) Required Primary Key
• Guid (datatype: uniqueidentifier) Required Primary Key
• CreatedDateTime (datatype: datetime) Required Primary Key
• ModifiedDateTime (datatype: datetime) Required Primary Key
• CreatedByPersonAliasId (datatype: int) Required Primary Key
• ModifiedByPersonAliasId (datatype: int) Required Primary Key
• OpenedDateTime (datatype: datetime) Required Primary Key
• OpenedClient (datatype: nvarchar(200)) Required Primary Key
• ForeignKey (datatype: nvarchar(100)) Required Primary Key
• TransportEntityTypeName (datatype: nvarchar(100)) Required Primary Key
• UniqueMessageId (datatype: nvarchar(100)) Required Primary Key
• ResponseCode (datatype: nvarchar(6)) Required Primary Key
• PersonAliasId (datatype: int) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• MediumEntityTypeId (datatype: int) Required Primary Key
• SendDateTime (datatype: datetime) Required Primary Key
• SentMessage (datatype: nvarchar(max)) Required Primary Key
• PersonalDeviceId (datatype: int) Required Primary Key