Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 ContextID int
 Status int   Default = 0

Foreign Key Field Type Null Notes Description
 UserID int ClientUsers.ID
 NotificationID int   NC_Notification.ID
 BackOfficeSystemPeopleID int BackOfficeSystemPeople.ID
 BackOfficeSystemsID int BackOfficeSystems.ID

Index Name Field(s) Unique Primary Clustered
 IX_NotificationSubscription_NotificationID_UserID NotificationID, UserID      
 PK_NotificationSubscription ID  

Entity-Relationship diagram of this table