Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Body | Unknown | 0 | null |
|
|
Email body - HTML or text content of the email template |
||
| CreatedBy | Unknown | 0 | null |
|
|
Creator user ID - Reference to user who created this template |
||
| DateCreated | Unknown | 0 | null |
|
|
Creation timestamp - When this template was first created |
||
| DateUpdated | Unknown | 0 | null |
|
|
Last modification timestamp - When this template was most recently updated |
||
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each email template, auto-incrementing integer |
|
| GroupId | int | 4 | √ | null |
|
|
Group identifier - Reference to template group for organizational purposes |
|
| Type | nvarchar | 100 | √ | null |
|
|
Template type code - Coded classification of the email template type |
|
| HtmlTemplate | nvarchar | 1073741823 | √ | null |
|
|
HTML template content - Rich HTML version of the email template |
|
| IsActive | Unknown | 0 | null |
|
|
Active status - Boolean indicating if template is currently active and available |
||
| Subject | nvarchar | 1073741823 | √ | null |
|
|
Email subject - Subject line template with support for dynamic variables |
|
| TemplateName | Unknown | 0 | null |
|
|
Template name - Descriptive name for the email template |
||
| TemplateType | Unknown | 0 | null |
|
|
Template type - Classification of template usage (Notification, Welcome, Reminder, etc.) |
||
| UpdatedBy | Unknown | 0 | null |
|
|
Last modifier - User ID who made the most recent update |