UserNotifications


Columns

Column Type Size Nulls Auto Default Children Parents Comments
UserNotificationId uniqueidentifier 16 null
UserId uniqueidentifier 16 null
Users.UserId UserNotifications_Users_ForeignKey R
NotificationId uniqueidentifier 16 null
Notifications.NotificationId UserNotifications_Notifications_ForeignKey R
NotificationDate datetime 16 null
Mail nvarchar 240 null
Message nvarchar 2147483647 null

Table contained 38 rows

Indexes

Constraint Name Type Sort Column(s)
UserNotifications_PrimaryKey Primary key Asc UserNotificationId
UserNotifications_UserNotificationId_Index Performance Asc UserNotificationId
UserNotifications_UserNotificationId_UniqueKey Must be unique Asc UserNotificationId

Relationships