Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
SurveyResultKey | uniqueidentifier | 16 | √ | null |
|
|
||
SurveyKey | uniqueidentifier | 16 | √ | null |
|
|
||
SurveyName | varchar | 250 | √ | null |
|
|
||
ParticipantIdentifier | varchar | 250 | √ | null |
|
|
||
SurveyTaskKey | uniqueidentifier | 16 | √ | null |
|
|
||
Type | varchar | 250 | √ | null |
|
|
||
SurveyVersion | varchar | 250 | √ | null |
|
|
||
StartDate | datetime2 | 16,7 | √ | null |
|
|
||
EndDate | datetime2 | 16,7 | √ | null |
|
|
||
DeviceInfo.Name | varchar | 250 | √ | null |
|
|
||
DeviceInfo.OSVersion | varchar | 250 | √ | null |
|
|
||
DeviceInfo.Platform | varchar | 250 | √ | null |
|
|
||
InsertedDate | datetime2 | 16,7 | √ | null |
|
|
||
StepResults | nvarchar | 2147483647 | √ | null |
|
|
||
FileName | varchar | 250 | √ | null |
|
|
||
FileCreationDate | datetime2 | 16,7 | √ | null |
|
|
||
ProcessedDate | datetime2 | 16,7 | √ | null |
|
|