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