cf_Control


Description

Custom form controls defining individual form controls and input elements for dynamic custom forms. This table manages form controls including text fields, dropdowns, checkboxes, and other input elements with their properties, validation rules, and display characteristics for flexible form creation in healthcare documentation.

Columns

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

Control action - JavaScript or server action associated with the control
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
FormId int 4 null
cf_Form.Id FK_cf_Control_cf_Form C

Form reference - Links to cf_Form table for the parent form
ContainerId int 4 √ null
cf_Control.Id FK_cf_Control_cf_Control R

Container reference - Links to parent container control for nested controls
Name nvarchar 100 √ null

Control name - Unique name identifier for the form control
Label nvarchar 512 √ null

Control label - Display label text for the form control
Value nvarchar 1073741823 √ null

Default value - Default or current value for the form control
CodeType nvarchar 512 √ null

Code type - Type of coding or validation applied to the control
ValueType nvarchar 512 √ null

Value type - Data type specification for the control value (text, number, date, etc.)
OrderPosition int 4 √ null

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

Action method - HTTP method or processing method for control actions

Indexes

Constraint Name Type Sort Column(s)
PK__cf_Contr__3214EC076174EB03 Primary key Asc Id
IX_ContainerID Performance Asc ContainerId
IX_Control Performance Asc FormId

Relationships

Close relationships within degrees of separation