cf_ControlTemplate


Description

Form control template definitions storing reusable control templates that define standard control configurations for consistent form design. These templates provide blueprints for creating controls with predefined properties and behaviors.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
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, auto-incrementing integer
FormTemplateId int 4 null

Form template reference - Foreign key linking to cf_FormTemplate containing this control template (required field)
ContainerId int 4 √ null
cf_ControlTemplate.Id FK_cf_ControlTemplate_cf_ControlTemplate R

Container reference - Optional reference to parent container template for hierarchical layout
Name nvarchar 100 √ null

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

Default label - Default display label for controls created from this template
CodeType nvarchar 512 √ null

Control type - Type classification defining what kind of control this template creates
OrderPosition int 4 √ null

Template order - Numeric position for ordering control templates within form templates
Value nvarchar 1073741823 √ null

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

Data type - Data type specification for values in controls created from this template
Method nvarchar 100 √ null

Template method - Default processing method for controls created from this template

Indexes

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

Relationships

Close relationships within degrees of separation