SurveyDefinitionConfiguration


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SurveyDefinitionKey uniqueidentifier 16 √ null
SurveyDefinitionFileName varchar 250 √ null
SurveyKey uniqueidentifier 16 √ null
SurveyName varchar 250 √ null
VersionNumber varchar 250 √ null
DefinitionJSON nvarchar 2147483647 √ null
DefinitionType varchar 500 √ null
DefinitionName varchar 500 √ null
DefinitionIdentifier varchar 500 √ null
DefinitionKeepAwake varchar 500 √ null
StepType varchar 100 √ null
StepActionType varchar 255 √ null
StepDuration varchar 100 √ null
StepTitle varchar 2000 √ null
StepText varchar 2000 √ null
StepIdentifier varchar 1000 √ null
StepHTML nvarchar 2147483647 √ null
StepHeight varchar 100 √ null
StepParameterWorkoutDescription varchar 1000 √ null
StepParameterNoAppleWatchMessage varchar 1000 √ null
StepParameterFailureMessage varchar 1000 √ null
StepParameterTimeoutMessage varchar 1000 √ null
FormItemIdentifier varchar 100 √ null
FormItemType varchar 100 √ null
FormItemText varchar 2000 √ null
FormItemOptional varchar 1000 √ null
FormItemAnswertype varchar 100 √ null
FormItemAnswerMinimumValue int 4 √ null
FormItemAnswerMinimumValueDescription varchar 1000 √ null
FormItemAnswerMaximumValue int 4 √ null
FormItemAnswerMaximumValueDescription varchar 1000 √ null
FormItemAnswerMaximumFractionDigits int 4 √ null
FormItemAnswerDefaultValue varchar 1000 √ null
StepAnswertype varchar 100 √ null
StepAnswerTextChoiceType varchar 100 √ null
StepAnswerTextChoiceText varchar 1000 √ null
StepAnswerTextChoiceValue varchar 1000 √ null

Indexes

Constraint Name Type Sort Column(s)
NonClusteredIndex-FormItemIdentifier-20211203-102520 Performance Asc FormItemIdentifier
NonClusteredIndex-FormItemType-20211203-102706 Performance Asc FormItemType
NonClusteredIndex-StepIdentifier-20211203-102603 Performance Asc StepIdentifier
NonClusteredIndex-StepType-20211203-102735 Performance Asc StepType
NonClusteredIndex-SurveyKey-20211203-102428 Performance Asc SurveyKey
NonClusteredIndex-VersionNumber-20211203-102636 Performance Asc VersionNumber

Relationships