Assignments questionnaires: Difference between revisions
Jump to navigation
Jump to search
(Created page with "'''Deprecated''' {| class="wikitable" !Field Name !!Type !!Description |- !id |int(11) |The unique record id |- !questionnaire_id |int(11) |This references the ques...") |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
'''Deprecated''' | '''Deprecated''' | ||
== Assignments Questionnaire Variable Documentation == | |||
{| class="wikitable" | {| class="wikitable" | ||
| Line 10: | Line 11: | ||
!questionnaire_id | !questionnaire_id | ||
|int(11) | |int(11) | ||
|This references | |This references a questionnaire that is used in t he assignment | ||
|- | |- | ||
!assignment_id | !assignment_id | ||
|int(11) | |int(11) | ||
|This references the assignment in which the questionnaire is used | |||
|This references the | |- | ||
|} | !notification_limit | ||
|int | |||
|If a new review has a score that is more than this # of percentage points away from the current average review score for this artifact, then the instructor will be emailed. | |||
|- | |||
!questionnaire_weight | |||
|int | |||
|Gives the percentage of the contributor's overall score that is based on this questionnaire. | |||
|- | |||
!used_in_round | |||
|int | |||
|Tells which round (1, 2, ...) of review this questionnaire is used in. If null, I suspect that the questionnaire is used in all rounds. | |||
|- | |||
!dropdown | |||
|tinyint(1) | |||
|I believe that if this is true, instead of using a rubric to evaluate this kind of work (e.g., review of work, teammate review), a simple dropdown with integers from 1 to MAX_SCORE is used instead. | |||
|- | |||
!topic_id | |||
|int | |||
|If this field is non-null, then this rubric is used only to review this particular topic. | |||
|- | |||
!duty_id | |||
|int | |||
|If this is non-null, then this rubric is used only to review a team member who takes on a particular role (such as scrum master, tester, or documentor). | |||
|- | |||
|} | |||
== E/R diagram for Parents Tables == | |||
Tables referred by the Assignment Badges Table as Foreign Key Relationship. | |||
[[File:assignments_questionnaires_imported.png]] | |||
== E/R diagram for Child Tables == | |||
No Tables refer the Assignment Badges Table as Foreign Key Relationship. | |||
Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page. | Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page. | ||
Latest revision as of 01:01, 24 November 2024
Deprecated
Assignments Questionnaire Variable Documentation
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | The unique record id |
| questionnaire_id | int(11) | This references a questionnaire that is used in t he assignment |
| assignment_id | int(11) | This references the assignment in which the questionnaire is used |
| notification_limit | int | If a new review has a score that is more than this # of percentage points away from the current average review score for this artifact, then the instructor will be emailed. |
| questionnaire_weight | int | Gives the percentage of the contributor's overall score that is based on this questionnaire. |
| used_in_round | int | Tells which round (1, 2, ...) of review this questionnaire is used in. If null, I suspect that the questionnaire is used in all rounds. |
| dropdown | tinyint(1) | I believe that if this is true, instead of using a rubric to evaluate this kind of work (e.g., review of work, teammate review), a simple dropdown with integers from 1 to MAX_SCORE is used instead. |
| topic_id | int | If this field is non-null, then this rubric is used only to review this particular topic. |
| duty_id | int | If this is non-null, then this rubric is used only to review a team member who takes on a particular role (such as scrum master, tester, or documentor). |
E/R diagram for Parents Tables
Tables referred by the Assignment Badges Table as Foreign Key Relationship.
E/R diagram for Child Tables
No Tables refer the Assignment Badges Table as Foreign Key Relationship.
Back to Database Tables Main page.