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
Close relationships within degrees of separation
