EmailList
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientsID | int | |||
| OwnerID | int | |||
| Deleted | bit | Default = 0 | ||
| Name | nvarchar(256) | yes | ||
| Description | nvarchar(256) | yes | ||
| Guid | uniqueidentifier | |||
| Subscription | bit | Default = 0 | ||
| Type | int | Default = 0 | ||
| DataSourceID | int | Default = 1 | ||
| Options | ntext | yes | ||
| AcquiredStatus | int | Default = 0 | ||
| AcquiredDate | datetime | yes | Default = getutcdate() | |
| AcquiredStartDate | datetime | yes | Default = getutcdate() | |
| AcquiredRecordCount | int | yes | ||
| ListDataSchema | ntext | yes | ||
| EmailDisplayNameFieldName | nvarchar(128) | yes | ||
| EmailAddressFieldName | nvarchar(128) | yes | ||
| UniqueKeyFieldName | nvarchar(128) | yes | ||
| FileContents | image | yes | ||
| UploadfileName | nvarchar(256) | yes | ||
| UploadFileSize | int | yes | ||
| AcquiredMsg | ntext | yes | ||
| UploadedDataSourceID | int | yes | ||
| Origin | tinyint | yes | ||
| UserImportID | int | yes | ||
| BBDMListID | nvarchar(255) | yes | ||
| SystemList | bit | Default = 0 | ||
| SITEFOLDERSID | int | Default = 0 |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientSitesID | int | ClientSites.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_EmailList_BBDMListID | BBDMListID | |||
| IX_EmailList_GUID_OwnerID_Deleted | Guid, OwnerID, Deleted | |||
| IX_EmailList_ClientSitesID_Name | ClientSitesID, Name | yes | ||
| PK_EmailList | ID | yes | yes | yes |
Triggers
| Trigger Name | Description |
|---|---|
| TR_EmailList_CASCDE_DEL_1 |
Referenced by
| Referenced by | Field |
|---|---|
| Chapters | MemberEmailListID |
| CONDITIONALCONTENTRECIPIENT | EMAILLISTID |
| ConditionList | EmailListID |
| Email_EmailList | EmailListID |
| EmailList_Subscription | EmailListID |
| EmailProjectAppeal_Duplicates | EmailListID |
| EMAILSCHEDULE_EMAILLIST | EMAILLISTID |
| EmailTemplate_EmailList | EmailListID |
| FAFEVENTEMAIL | EMAILLISTID |