FlexForm


Description

Flexible form definitions - Master table defining flexible, configurable forms for dynamic data collection and custom documentation. This table stores form metadata, validation scripts, hierarchical relationships, and addon configurations to support customizable healthcare forms, assessment instruments, and data collection workflows.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkFlexFormID int identity 4 √ null
FlexFormSettings.fkFlexFormID FK_FlexFormSettings_FlexForm R
StoredProcInFlexForm.fkFlexFormID FK_StoredProcinFlexForm_FlexForm R

Form primary key - Unique identifier for each flexible form definition
FlexFormName varchar 100 √ null

Form name - Descriptive name for the flexible form
FlexFormDescription varchar 2000 √ null

Form description - Detailed description of the form’s purpose and usage
validationScript text 2147483647 √ null

Validation script - JavaScript or other script code for form validation
ParentFlexFormID int 4 √ null

Parent form reference - Links to parent form for hierarchical form structures
AddonFormCode varchar 30 √ null

Addon form code - Code identifying addon or extension forms

Indexes

Constraint Name Type Sort Column(s)
PK__FlexForm__2B21D60B Primary key Asc pkFlexFormID

Relationships

Close relationships within degrees of separation