Assignment questionnaires: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 37: | Line 37: | ||
|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]] | [[File:assignment_questionnaire_imported.png]] | ||
Back to the [[Documentation_on_Database_Tables|database documentation]] | Back to the [[Documentation_on_Database_Tables|database documentation]] | ||
Revision as of 00:42, 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. |
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