Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| Id | id | 18 | null |
|
|
Label: Email Message ID |
||||
| ParentId | reference | 18 | null |
|
|
Label: Case ID |
||||
| ActivityId | reference | 18 | null |
|
|
Label: Activity ID |
||||
| CreatedById | reference | 18 | null |
|
|
Label: Created By ID |
||||
| CreatedDate | datetime | 0 | null |
|
|
Label: Created Date |
||||
| LastModifiedDate | datetime | 0 | null |
|
|
Label: Last Modified Date |
||||
| LastModifiedById | reference | 18 | null |
|
|
Label: Last Modified By ID |
||||
| SystemModstamp | datetime | 0 | null |
|
|
Label: System Modstamp |
||||
| TextBody | textarea | 32000 | null |
|
|
Label: Text Body |
||||
| HtmlBody | textarea | 32000 | null |
|
|
Label: HTML Body |
||||
| Headers | textarea | 32000 | null |
|
|
Label: Headers |
||||
| Subject | string | 3000 | null |
|
|
Label: Subject |
||||
| FromName | string | 1000 | null |
|
|
Label: From Name |
||||
| FromAddress | 1000 | null |
|
|
Label: From Address |
|||||
| ToAddress | string | 4000 | null |
|
|
Label: To Address |
||||
| CcAddress | string | 4000 | null |
|
|
Label: CC Address |
||||
| BccAddress | string | 4000 | null |
|
|
Label: BCC Address |
||||
| Incoming | boolean | 0 | null |
|
|
Label: Is Incoming |
||||
| HasAttachment | boolean | 0 | null |
|
|
Label: Has Attachment |
||||
| Status | picklist | 40 | null |
|
|
Label: Status |
||||
| MessageDate | datetime | 0 | null |
|
|
Label: Message Date |
||||
| IsDeleted | boolean | 0 | null |
|
|
Label: Deleted |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| FakeIndex74 | Must be unique | Asc | Id |