Assignments questionnaires

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.