EmailList_People
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EmailListID | int | |||
| PeopleID | int | |||
| EmailDisplayName | nvarchar(128) | yes | ||
| EmailAddress | nvarchar(255) | yes | ||
| QueryID | int | yes | ||
| GlobalOptOut | bit | Default = 0 |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_EmailList_People_EmailAddress_EmailListID_PeopleID | EmailAddress, EmailListID, PeopleID | |||
| IX_EmailList_People_EmailListID_ID_EmailDisplayName_QueryID | EmailListID | |||
| IX_EmailList_People_EmailListID_PeopleID | EmailListID, PeopleID | |||
| PK_EmailList_People | ID | yes | yes | yes |