Assignment questionnaires: Difference between revisions
Jump to navigation
Jump to search
(Created page with "The assignment_questionnaires table defines the joins between a questionnaire and an assignment. It is also used to associate default limits fo...") |
|||
| Line 28: | Line 28: | ||
|int(11) | |int(11) | ||
|A percentage that the [[questionnaires|questionnaire]] contributes to the overall score. When both assignment_id and questionnaire_id are null, this relationship defines the defaults set by the instructor. | |A percentage that the [[questionnaires|questionnaire]] contributes to the overall score. When both assignment_id and questionnaire_id are null, this relationship defines the defaults set by the instructor. | ||
|- | |||
!used_in_round | |||
|int(11) | |||
|Questionnaire used in which particular round. | |||
|- | |||
!used_in_round | |||
|tinyint(1) | |||
|Indicating whether a dropdown is present or not. | |||
|} | |} | ||
Back to the [[Documentation_on_Database_Tables|database documentation]] | Back to the [[Documentation_on_Database_Tables|database documentation]] | ||
Revision as of 00:24, 23 April 2018
The assignment_questionnaires table defines the joins between a questionnaire and an assignment. It is also used to associate default limits for the notifications an instructor receives.
Assignment Questionnaires variable documentation
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | The unique record id |
| assignment_id | int(11) | The ID of the assignment in this relationship. A null value is used to define the default limits |
| questionnaire_id | int(11) | The ID of the questionnaire in this relationship. A null value is used to define the default limits |
| user_id | int(11) | The ID of the instructor who created the relationship |
| notification_limit | int(11) | A percent difference between an awarded score and the current average score as an integer. This defines at which point the instructor receives a notification that a response falls outside the acceptable range |
| questionnaire_weight | int(11) | A percentage that the questionnaire contributes to the overall score. When both assignment_id and questionnaire_id are null, this relationship defines the defaults set by the instructor. |
| used_in_round | int(11) | Questionnaire used in which particular round. |
| used_in_round | tinyint(1) | Indicating whether a dropdown is present or not. |
Back to the database documentation