cf_Control


Description

Dynamic form control management storing individual form controls (fields, buttons, inputs) within form instances. Each control represents a specific user interface element with its configuration, validation rules, and data binding for flexible form construction and user interaction.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
cf_Control.ContainerId FK_cf_Control_cf_Control R
cf_Control_Extend.ControlId FK_cf_Control_Extend_cf_Control1 C

Primary key - Unique identifier for each form control, auto-incrementing integer
FormId int 4 null
cf_Form.Id FK_cf_Control_cf_Form C

Form reference - Foreign key linking to cf_Form for the form containing this control (required field)
ContainerId int 4 √ null
cf_Control.Id FK_cf_Control_cf_Control R

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

Control name - Unique name identifier for the control used in form processing and data binding
Label nvarchar 512 √ null

Control label - Display label shown to users for this form control
Value nvarchar 1073741823 √ null

Control value - Current value or default value of the form control
CodeType nvarchar 512 √ null

Control type - Type classification of the control (e.g., TextBox, DropDown, CheckBox) for rendering
ValueType nvarchar 512 √ null

Data type - Data type of the control value (e.g., String, Integer, Date) for validation and processing
OrderPosition int 4 √ null

Display order - Numeric position for ordering controls within the form layout
Method nvarchar 100 √ null

Control method - Processing method or behavior associated with this control

Indexes

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

Relationships

Close relationships within degrees of separation