EMAILQUEUETRANSACTIONAL
Holds pending transactional emails. Since this is a queue, no audit trail is required.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| RECIPIENTDATA |
xml |
|
|
This field will contain the recipient dataset for this email. |
| EMAILHEADER |
xml |
|
|
Contains the email information (except for the body). Fields such as To, From, etc. with merge field placeholders. |
| CONTENTTEXT |
nvarchar(max) |
|
Default = '' |
Contains the email content information in text format with merge field placeholders. |
| CONTENTHTML |
nvarchar(max) |
|
Default = '' |
Contains the email content information in HTML format with merge field placeholders. |
| THREADID |
uniqueidentifier |
|
|
Contains a unique guid used to determine which emails are being processed by current loop |
| RETRYNUMBER |
tinyint |
|
Default = 0 |
Contains a 0 based number indicating which retry we are currently on. |
| DATEADDEDTOQUEUE |
datetime |
|
Default = getdate() |
Contains the date and time the email was added to the queue. This is needed since the Audit trail fields are not included. |
| SOURCE |
int |
|
Default = 0 |
Identifies the calling application. Used to determine priority. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_EMAILQUEUETRANSACTIONAL_THREADID |
THREADID |
|
|
|
| PK_EMAILQUEUETRANSACTIONAL |
ID |
yes |
yes |
yes |
Referenced by