Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkFlexFormSettingsID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each flexible form field setting configuration |
||||
| fkFlexFormID | int | 4 | null |
|
|
Flexible form reference - Links to FlexForm table for the form containing this field configuration (foreign key to FlexForm.pkFlexFormID) |
|||||
| fkSPID | int | 4 | null |
|
|
Stored procedure reference - Links to StoredProc table for data processing and validation logic (foreign key to StoredProc.pkSPID) |
|||||
| fkFieldID | int | 4 | √ | null |
|
|
Field definition reference - Links to Fields table for the specific field being configured (foreign key to Fields.PKFieldID) |
||||
| required | bit | 1 | √ | null |
|
|
Required field flag - Boolean indicator whether this field is required for form submission and validation |
||||
| Output | bit | 1 | √ | null |
|
|
Output field flag - Boolean indicator whether this field should be included in form output and reports |
||||
| bit | 1 | √ | null |
|
|
Hidden field flag - Boolean indicator whether this field should be hidden from user interface display |
|||||
| SQLString | varchar | 4000 | √ | null |
|
|
Custom SQL query - Custom SQL string for dynamic data retrieval, validation, or field population logic |
||||
| fkControlTypeID | int | 4 | √ | null |
|
|
Control type reference - Links to control type definition for UI rendering (e.g., textbox, dropdown, checkbox) |
||||
| ValuesString | varchar | 1000 | √ | null |
|
|
Field values configuration - Comma-separated or formatted string defining available values for dropdown lists or selection controls |
||||
| fkRegExpID | int | 4 | √ | null |
|
|
Regular expression reference - Links to RegExp table for field validation pattern matching (foreign key to RegExp.pkRegExpID) |
||||
| deleted | bit | 1 | √ | null |
|
|
Deletion flag - Boolean indicator for soft deletion of field configuration settings |
||||
| defaultValue | varchar | 1000 | √ | null |
|
|
Default field value - Pre-populated default value for the field when form is initially displayed |
||||
| requiredByUser | bit | 1 | √ | null |
|
|
User-defined required flag - Boolean indicator for user-customizable required field settings |
||||
| frontEndName | varchar | 100 | √ | null |
|
|
Display field name - User-friendly field name displayed in the form interface |
||||
| descr | varchar | 8000 | √ | null |
|
|
Field description - Detailed description of field purpose, usage instructions, and help text for users |
||||
| ShowOrder | int | 4 | √ | null |
|
|
Display order - Numeric order for field presentation and layout in the form interface |
||||
| FFieldName | varchar | 50 | √ | null |
|
|
Form field name - Internal field name used for form processing and data mapping |
||||
| DDataType | varchar | 20 | √ | null |
|
|
Data type - Data type specification for field validation and processing (e.g., string, integer, date) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__FlexFormSettings__72736894 | Primary key | Asc | pkFlexFormSettingsID |
Relationships
Close relationships within degrees of separation
