.

Generated using SQL Data Dictionary demo version.

Table dbo.CoreMessaging_NotificationTypes (15 rows)

	Column	Data Type	Identity	Nullable	Default
PK	NotificationTypeID	int	X
UK	Name	nvarchar(100)
	Description	nvarchar(2000)		X
	TTL	int		X
FK	DesktopModuleID	int		X
	CreatedByUserID	int		X
	CreatedOnDate	datetime		X
	LastModifiedByUserID	int		X
	LastModifiedOnDate	datetime		X

Indexes:

PK_CoreMessaging_NotificationTypes
- (Primary Key)
- (Clustered)
- NotificationTypeID

IX_CoreMessaging_NotificationTypes
- (Unique)
- Name

References:

dbo.DesktopModules
- DesktopModuleID

Referenced by:

dbo.CoreMessaging_Messages
- NotificationTypeID
dbo.CoreMessaging_NotificationTypeActions
- NotificationTypeID

Used by:

Procedure
dbo.CoreMessaging_CreateNotificationType
Procedure
dbo.CoreMessaging_DeleteNotificationType
Procedure
dbo.CoreMessaging_GetNotificationType
Procedure
dbo.CoreMessaging_GetNotificationTypeByName