| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 ID |
int | |||
| REID |
int |  |
||
| HasOpted |
bit | Default = 1 | ||
| BackofficeSystemPeopleID |
int | |
||
| EmailAddress |
nvarchar(255) | |
||
| FirstName |
nvarchar(255) | |
||
| LastName |
nvarchar(255) | |
||
| UpdateDate |
datetime | Default = getutcdate() |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 EmailListID |
int | EmailList.ID | ||
| UserID |
int | |
ClientUsers.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_EmailList_Subscription_PeepsID_UserID |
BackofficeSystemPeopleID, UserID | |||
| IX_EmailList_Subscription_UserID_PeepsID |
UserID, BackofficeSystemPeopleID |
| Trigger Name | Description |
|---|---|
 TR_EmailList_Subscription_Update |