.

Generated using SQL Data Dictionary demo version.

Table dbo.CoreMessaging_Subscriptions (0 rows)

	Column	Data Type	Identity	Nullable	Default
PK	SubscriptionId	int	X
FK	UserId	int
FK	PortalId	int		X
FK	SubscriptionTypeId	int
	ObjectKey	nvarchar(255)		X
	ObjectData	nvarchar(max)		X
	Description	nvarchar(255)
	CreatedOnDate	datetime
FK	ModuleId	int		X
	TabId	int		X

Indexes:

PK_CoreMessaging_Subscriptions
- (Primary Key)
- (Clustered)
- SubscriptionId

References:

dbo.Modules
- ModuleID (ModuleId)
dbo.Portals
- PortalID (PortalId)
dbo.CoreMessaging_SubscriptionTypes
- SubscriptionTypeId
dbo.Users
- UserID (UserId)

Used by:

Procedure
dbo.CoreMessaging_AddSubscription
Procedure
dbo.CoreMessaging_DeleteSubscription
Procedure
dbo.CoreMessaging_GetSubscriptionsByContent
Procedure
dbo.CoreMessaging_GetSubscriptionsByUser
Procedure
dbo.CoreMessaging_IsSubscribed
Procedure
dbo.CoreMessaging_UpdateSubscriptionDescription