questionnaire table columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| course | BIGINT | 19 | 0 |
|
|
Id of course |
||||
| name | VARCHAR | 255 |
|
|
Name for questionnaire. |
|||||
| intro | LONGTEXT | 2147483647 | null |
|
|
Description text. |
||||
| introformat | SMALLINT | 5 | 0 |
|
|
text format of intro field |
||||
| qtype | BIGINT | 19 | 0 |
|
|
Questionnaire type code. |
||||
| respondenttype | VARCHAR | 9 | fullname |
|
|
Eligible respondents |
||||
| resp_eligible | VARCHAR | 8 | all |
|
|
Eligible respondents. |
||||
| resp_view | TINYINT | 3 | 0 |
|
|
Questionnaire viewed? |
||||
| notifications | BIT | 1 | 0 |
|
|
Send submission notifications. |
||||
| opendate | BIGINT | 19 | 0 |
|
|
Timestamp to open access |
||||
| closedate | BIGINT | 19 | 0 |
|
|
Timestamp to close access on |
||||
| resume | TINYINT | 3 | 0 |
|
|
Questionnaire can be saved and resumed. |
||||
| TINYINT | 3 | 0 |
|
|
Questionnaire can have page branching. |
|||||
| grade | BIGINT | 19 | 0 |
|
|
Assign a grade to be received on submission. |
||||
| sid | BIGINT | 19 | 0 |
|
|
The id entry in the questionnaire_survey field. |
||||
| timemodified | BIGINT | 19 | 0 |
|
|
The timestamp record last modified. |
||||
| completionsubmit | BIT | 1 | 0 |
|
|
Questionnaire marked as 'complete' when submitted. |
||||
| autonum | BIT | 1 | 3 |
|
|
option for auto numbering questions and pages (both selected by default) |
||||
| progressbar | BIT | 1 | 0 |
|
|
Display a progress bar at top of questionnaire. |
Table contained -1 rows
questionnaire table indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| ques_cou_ix | Performance | Asc | course |
| ques_res_ix | Performance | Asc | resp_view |
| ques_sid_ix | Performance | Asc | sid |
questionnaire table relationships
Close relationships within degrees of separation
