# EmailTemplate: Email Template
- Name: `EmailTemplate`
- Catalog: `Salesforce`
- Schema: `Salesforce`
- Primary Keys: `id`
- Label: Email Template
## Table Columns
The columns of the table `EmailTemplate` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `ApiVersion` | `double` | API Version | ☐ | |
| `Body` | `string` | Body | ☐ | |
| `BrandTemplateId` | `string` | Brand Template ID | ☐ | |
| `CreatedById` | `string` | Created by ID | ☐ | |
| `CreatedDate` | `datetime` | Date Created | ☐ | |
| `Description` | `string` | Description | ☐ | |
| `DeveloperName` | `string` | Developer Name | ☐ | |
| `Encoding` | `string` | Encoding | ☐ | |
| `FolderId` | `string` | Folder ID | ☐ | |
| `HtmlValue` | `string` | HTML Value | ☐ | |
| `Id` | `string` | ID | ☐ | |
| `IsActive` | `boolean` | Is Active | ☐ | |
| `LastModifiedById` | `string` | Last Modified by ID | ☐ | |
| `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | |
| `LastUsedDate` | `datetime` | Last Used Date | ☐ | |
| `Markup` | `string` | Markup | ☐ | |
| `Name` | `string` | Name | ☐ | |
| `NamespacePrefix` | `string` | Namespace Prefix | ☐ | |
| `OwnerId` | `string` | Owner ID | ☐ | |
| `RelatedEntityType` | `string` | Related Entity Type | ☐ | |
| `Subject` | `string` | Subject | ☐ | |
| `SystemModstamp` | `datetime` | System Modstamp | ☐ | |
| `TemplateStyle` | `string` | Template Style | ☐ | |
| `TemplateType` | `string` | Template Type | ☐ | |
| `TimesUsed` | `int32` | Times Used | ☐ | |
| `UiType` | `string` | UI Type | ☐ | |