| Primary Key | Field Type |
|---|---|
 ID |
int |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 ClientSitesID |
int |  |
||
| Title |
nvarchar(256) | |
||
| TitleVisible |
bit | Default = 1 | ||
| SubTitle |
nvarchar(1024) | |
||
| SubTitleVisible |
bit | Default = 0 | ||
| LastActivityDate |
datetime | |
||
| PrevButtonVisible |
bit | Default = 1 | ||
| ExitButtonVisible |
bit | Default = 1 | ||
| AllowMultipleSubmit |
bit | Default = 0 | ||
| OnSubmitMsg |
nvarchar(1024) | |
||
| AllowViewResults |
bit | |
||
| State |
int | Default = 1 | 0-Test; 1-Open; 2-Closed | |
| ClosedMsg |
nvarchar(1024) | |
||
| SubmitButtonText |
nvarchar(40) | |
||
| NextButtonText |
nvarchar(40) | |
||
| PrevButtonText |
nvarchar(40) | |
||
| ExitButtonText |
nvarchar(40) | |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 ID |
int | SiteContent.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
| PK_SiteSurveys |
ID | |
|
|
| Referenced by | Field |
|---|---|
 SiteSurveyQuestions |
SiteSurveysId |
| SiteSurveyResponses |
SiteSurveysId |