| 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 |  |  | 
