Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| TemplateID | int identity | 4 | √ | null |
|
|
Template primary key - Unique identifier for each documentation template |
||||
| TemplateName | varchar | 150 | √ | null |
|
|
Template name - Descriptive name for the template |
||||
| TemplateContent | ntext | 1073741823 | √ | null |
|
|
Template content - Rich text content of the template including formatting and placeholders |
||||
| TemplateDesc | varchar | 1000 | √ | null |
|
|
Template description - Detailed description of the template’s purpose and usage |
||||
| Status | varchar | 100 | √ | null |
|
|
Template status - Current status of the template (Active, Inactive, Draft, etc.) |
||||
| fkSubTabID | int | 4 | √ | null |
|
|
Sub-tab reference - Links to sub-tab or category for template organization |
||||
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when this template was created |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this template |
||||
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last update date - Date when this template was last modified |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this template |
||||
| LockedBy | int | 4 | √ | null |
|
|
Locked by user - UserID of the person who has locked this template for editing |
||||
| Deleted | bit | 1 | √ | null |
|
|
Deletion flag - Soft delete flag for audit trail purposes |
||||
| DateLocked | smalldatetime | 16 | √ | null |
|
|
Lock date - Date when this template was locked for editing |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__iTemplate__64853BF0 | Primary key | Asc | TemplateID |
Relationships
Close relationships within degrees of separation
