NewsFeedItemRecipient table - SuperOffice

NewsFeedItemRecipient Table (509)

Recipients of the news feed item. One news feed item may be sent to multiple recipients (users).

Fields

Name	Description	Type	Nullable
newsfeeditemrecipient_id	Primary key	PK	No
newsfeeditem_id	Foreign key to NewsFeedItem that this recipient belongs to.	FK NewsFeedItem	No
associate_id	Foreign key to user that should receive this news item.	FK associate	No
IsRead	Set to true when the recipient user has read the news feed item.	Bool	No
ReadAt	When the recipient user read the news feed item (UTC)	UtcDateTime	Yes

Indexes

Fields	Types	Description
newsfeeditem_id, associate_id	FK, FK	Unique

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
NewsFeedItem	Contains news feed items - published to one or more users, with one or more language descriptions

Replication Flags

None

Security Flags

No access control via user’s Role.