Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Body | Unknown | 0 | null |
|
|
Email body template - Template for the email body content with placeholders |
||
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each email template |
|
| GroupId | int | 4 | √ | null |
|
|
Template group - Group identifier for organizing related templates |
|
| HtmlTemplate | nvarchar | 1073741823 | √ | null |
|
|
HTML template - HTML content template for the email |
|
| IsActive | Unknown | 0 | null |
|
|
Active status - Boolean indicating if the template is currently active |
||
| Subject | nvarchar | 1073741823 | √ | null |
|
|
Email subject template - Subject line template for the email |
|
| TemplateID | Unknown | 0 | null |
|
|
Primary key - Unique identifier for each email template |
||
| TemplateName | Unknown | 0 | null |
|
|
Template name - Descriptive name for the email template |
||
| TemplateType | Unknown | 0 | null |
|
|
Template type - Category or type of email template |
||
| Type | nvarchar | 100 | √ | null |
|
|
Template type - Type or category of the email template |
Relationships
Close relationships within degrees of separation
