cf_ControlTemplate


Description

Custom form control templates defining reusable control templates for form creation. This table manages template definitions for form controls that can be reused across multiple forms, providing standardized control configurations, validation rules, and display properties for consistent form design.

Columns

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

Template category - Category classification for organizing control templates
ContainerId int 4 √ null
cf_ControlTemplate.Id FK_cf_ControlTemplate_cf_ControlTemplate R

Container reference - Links to parent container template for nested controls
CodeType nvarchar 512 √ null

Code type - Type of coding or validation for the template
ControlType Unknown 0 null

Control type - Type of form control (textbox, dropdown, checkbox, etc.)
CreatedBy Unknown 0 null

Created by user - UserID of the person who created the template
CreatedDate Unknown 0 null

Creation date - Date when the control template was created
DefaultLabel Unknown 0 null

Default label - Standard label text for this control template
DefaultValue Unknown 0 null

Default value - Standard default value for controls created from this template
Id int identity 4 √ null
cf_ControlTemplate.ContainerId FK_cf_ControlTemplate_cf_ControlTemplate R
cf_ControlTemplate_Extend.ControlId FK_cf_ControlTemplate_Extend_cf_ControlTemplate1 C

Primary key - Unique identifier for each control template
FormTemplateId int 4 null
cf_FormTemplate.Id FK_cf_ControlTemplate_cf_FormTemplate C

Form template reference - Links to cf_FormTemplate for the parent template
IsActive Unknown 0 null

Active status - Boolean flag indicating if the template is available for use
Name nvarchar 100 √ null

Template name - Unique name identifier for the control template
Label nvarchar 512 √ null

Template label - Default label text for controls created from this template
OrderPosition int 4 √ null

Order position - Display order within the form template
Method nvarchar 100 √ null

Method - Method or function associated with this template
Properties Unknown 0 null

Template properties - JSON or XML configuration of template properties
TemplateName Unknown 0 null

Template name - Descriptive name for the control template
ValidationRules Unknown 0 null

Validation rules - Standard validation rules applied to controls from this template
Value nvarchar 1073741823 √ null

Default value - Default value for controls created from this template
ValueType nvarchar 512 √ null

Value type - Data type specification for the template

Indexes

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

Relationships

Close relationships within degrees of separation