TextTemplates


Description

Text template management storing reusable text templates for documents, communications, and standardized content throughout the healthcare system. This table manages template content that can be used for generating consistent documentation, correspondence, and standardized text across various business processes and compliance requirements.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null

Primary key - Unique identifier for each text template
Name varchar 250 √ null

Template name - Descriptive name of the text template
Template ntext 1073741823 √ null

Template content - The actual template text with placeholders and formatting
DateCreated datetime 16,3 √ null

Creation date - Date and time when the template was created
CreatedBy int 4 √ null

Created by user - UserID of the person who created the template
DeletedDate datetime 16,3 √ null

Deletion date - Date when the template was soft-deleted

Indexes

Constraint Name Type Sort Column(s)
PK_TextTemplates Primary key Asc ID

Relationships

Close relationships within degrees of separation