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