TemplateContent


Description

Template content storage managing content and data for document templates and report templates used throughout the healthcare system. This table stores template content, formatting, and configuration data that can be used to generate standardized documents, reports, and forms for various business processes and compliance requirements.

Columns

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

Primary key - Unique identifier for each template content record

TempContent text 2147483647 null

Template content - The actual content, markup, or template data

fkTempTypeID int 4 null

Template type reference - Links to the type of template

fkReportID int 4 null

Report reference - Links to the associated report if applicable

footer ntext 1073741823 null

Template footer - Footer content for the template (HTML, text, or markup)

Indexes

Constraint Name Type Sort Column(s)
PK_tempContent Primary key Asc pkTempContentID

Relationships