Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| Name | nvarchar(255) | yes | ||
| Description | nvarchar(255) | yes | ||
| OwnerID | int | |||
| Deleted | bit | Default = 0 | ||
| Guid | uniqueidentifier | Default = (newid()) | ||
| Type | tinyint | Default = 0 | ||
| Status | tinyint | yes | ||
| ContentHTML | ntext | yes | ||
| ContentText | ntext | yes | ||
| FromAddress | nvarchar(255) | yes | ||
| FromDisplayName | nvarchar(255) | yes | ||
| Subject | nvarchar(4000) | yes | ||
| Priority | int | yes | ||
| ReplyAddress | nvarchar(255) | yes | ||
| ReturnReceipt | bit | Default = 0 | ||
| ReturnReceiptAddress | nvarchar(255) | yes | ||
| ForwardDSN | bit | Default = 0 | ||
| ForwardDSNAddress | nvarchar(255) | yes | ||
| SendAfterDate | datetime | Default = getutcdate() | ||
| CreateDate | datetime | Default = getutcdate() | ||
| ProjectAppealListEmailID | int | yes | ||
| ParentEmailID | int | yes | ||
| AppealID | int | yes | ||
| EmailAddressTypeID | uniqueidentifier | yes | ||
| InactiveRecipientFromMonths | int | yes | Default = 0 | |
| IsExcludeInactiveRecipient | bit | yes | Default = 0 | |
| AlternateSubject | nvarchar(255) | yes | Default = NULL |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EmailTemplateID | int | EmailTemplate.ID | ||
| ClientSitesID | int | yes | ClientSites.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_EMAIL__GUID_DELETED_OWNERID | Guid, Deleted, OwnerID | |||
| IX_Email_ID_EmailTemplateID_Subject | ID, EmailTemplateID | |||
| IX_Email_ParentEmailID | ParentEmailID | |||
| IX_Email_ProjectAppealListEmailID | ProjectAppealListEmailID | |||
| IX_USR_EMAIL_DELETED_CLIENTSITESID_TYPE | Deleted, ClientSitesID, Type | |||
| IX_USR_EMAIL_NAME_DELETED_CLIENTSITESID_ID | Name, Deleted, ClientSitesID, ID | |||
| PK_Email | ID | yes | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| Email_EmailList | EmailID |
| Email_Recipient | EmailID |
| EmailConditionBlock | EmailID |
| EmailJob | EmailID |
| EmailJob_Recipient | EmailID |
| EMAILJOB_RECIPIENT_DONATED | EMAILID |
| EmailJobStatus | EmailID |
| EMAILTESTADDRESSES | EMAILID |
| FAFEVENTEMAIL | EMAILID |
| RealmEmail | EmailID |