| Primary Key | Field Type |
|---|---|
ID |
int |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
Sequence |
int | |||
Page |
int | ![]() |
||
LinkText |
nvarchar(256) | ![]() |
||
Question |
nvarchar(256) | ![]() |
||
SubTitle |
nvarchar(1024) | ![]() |
||
RandomizeAnswers |
bit | Default = 0 | ||
Mandatory |
bit | Default = 0 | ||
MaxAnswerLen |
int | ![]() |
||
LastActivityDate |
datetime | ![]() |
||
ConstantSumValue |
int | ![]() |
||
SkipAutoNbr |
bit | Default = 0 |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
SiteSurveysId |
int | SiteSurveys.ID | ||
SiteSurveyQuestionTypesId |
int | SiteSurveyQuestionTypes.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
PK_SiteSurveyQuestions |
ID | ![]() |
![]() |
![]() |
| Referenced by | Field |
|---|---|
SiteSurveyAnswerColumns |
SiteSurveyQuestionsId |
SiteSurveyAnswers |
SiteSurveyQuestionsId |
SiteSurveyAnswers |
NextQuestionId |

ID
Sequence
SiteSurveysId