Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CreatedDate | Unknown | 0 | null |
|
|
Creation date - Date when the email was queued |
||
| EmailID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each queued email |
|
| ToEmail | varchar | 2147483647 | √ | null |
|
|
Recipient emails - Email addresses of recipients (comma-separated for multiple) |
|
| Subject | varchar | 1000 | √ | null |
|
|
Email subject - Subject line of the email |
|
| Body | varchar | 2147483647 | √ | null |
|
|
Email body - Content body of the email |
|
| Status | varchar | 10 | √ | null |
|
|
Email status - Status of the email (Queued, Sent, Failed, etc.) |
|
| fkiCommunicateID | int | 4 | √ | null |
|
|
Communication reference - Links to communication record if applicable |
|
| IsIncludeBodyInEmail | bit | 1 | √ | null |
|
|
Include body flag - Boolean indicating if body should be included in email |
|
| ScheduledSendDateTime | datetime | 16,3 | √ | null |
|
|
Scheduled send time - Date and time when email should be sent |
Relationships
Close relationships within degrees of separation
