cf_FormTemplate


Description

Custom form templates defining reusable form templates for creating dynamic forms. This table manages form template definitions including structure, actions, and methods that can be used to generate multiple form instances with consistent layouts and functionality for healthcare documentation and data collection.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
CreatedBy Unknown 0 null

Created by user - UserID of the person who created the template
Id int 4 null
cf_ControlTemplate.FormTemplateId FK_cf_ControlTemplate_cf_FormTemplate C
cf_Form.FormTemplateId FK_cf_Form_cf_FormTemplate R

Primary key - Unique identifier for each form template
FileName nvarchar 100 √ null

Template filename - File name for the form template
Action nvarchar 2000 √ null

Form action - Action or URL to process form submissions
IsPublic Unknown 0 null

Public access - Boolean flag indicating if the template is available to all users
Name nvarchar 100 √ null

Template name - Descriptive name of the form template
Method nvarchar 100 √ null

Form method - HTTP method for form submission (GET, POST, etc.)
TemplateCategory Unknown 0 null

Template category - Category classification for organizing form templates
TemplateDescription Unknown 0 null

Template description - Detailed description of the template’s purpose and usage
TemplateName Unknown 0 null

Template name - Descriptive name for the form template

Indexes

Constraint Name Type Sort Column(s)
PK__cf_FormT__3214EC07044D512D Primary key Asc Id

Relationships

Close relationships within degrees of separation