Assignment questionnaires: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
| (3 intermediate revisions by one other user not shown) | |||
| Line 33: | Line 33: | ||
|Questionnaire used in which particular round. | |Questionnaire used in which particular round. | ||
|- | |- | ||
! | !dropdown | ||
|tinyint(1) | |tinyint(1) | ||
|Indicating whether a dropdown is present or not. | |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 == | == 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