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