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...") |
mNo edit summary |
||
| (5 intermediate revisions by one other user not shown) | |||
| 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. | |||
|- | |||
!dropdown | |||
|tinyint(1) | |||
|Indicating whether a dropdown is present or not. | |||
|} | |} | ||
== E/R diagram for Parent Tables == | |||
The table Assignment_questionnaire has not referred to any other table. | |||
== E/R diagram for Child Tables == | |||
Tables which refer the Assignment_questionnaires Table as Foreign Key Relationship. | |||
[[File:assignment_questionnaire_imported.png]] | |||
Back to the [[Documentation_on_Database_Tables|database documentation]] | Back to the [[Documentation_on_Database_Tables|database documentation]] | ||
Latest revision as of 18:21, 27 May 2020
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. |
| dropdown | tinyint(1) | Indicating whether a dropdown is present or not. |
E/R diagram for Parent Tables
The table Assignment_questionnaire has not referred to any other table.
E/R diagram for Child Tables
Tables which refer the Assignment_questionnaires Table as Foreign Key Relationship.
Back to the database documentation