Assignments questionnaires - Revision history

Admin at 02:02, 2 April 2026

2026-04-02T02:02:01Z

← Older revision		Revision as of 02:02, 2 April 2026
Line 1:		Line 1:
	~~<div style="background-color: #ffcccc; border: 1px solid #cc0000; padding: 10px; margin-bottom: 20px; text-align: center;">~~
	~~'''⚠ DEPRECATED: This table has been removed from the database in the latest release. This documentation is retained for historical reference only.'''~~
	~~</div>~~
	~~'''Deprecated'''~~
	== Assignments Questionnaire Variable Documentation ==		== Assignments Questionnaire Variable Documentation ==

Bvgowda at 05:19, 9 December 2025

2025-12-09T05:19:00Z

← Older revision		Revision as of 05:19, 9 December 2025
Line 1:		Line 1:
			<div style="background-color: #ffcccc; border: 1px solid #cc0000; padding: 10px; margin-bottom: 20px; text-align: center;">
			'''⚠ DEPRECATED: This table has been removed from the database in the latest release. This documentation is retained for historical reference only.'''
			</div>
	'''Deprecated'''		'''Deprecated'''
	== Assignments Questionnaire Variable Documentation ==		== Assignments Questionnaire Variable Documentation ==

Admin: /* Assignments Questionnaire Variable Documentation */

2024-11-24T01:01:15Z

Assignments Questionnaire Variable Documentation

← Older revision		Revision as of 01:01, 24 November 2024
Line 18:		Line 18:
	\|-		\|-
	!notification_limit		!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.		\|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		!questionnaire_weight
			\|int
	\|Gives the percentage of the contributor's overall score that is based on this questionnaire.		\|Gives the percentage of the contributor's overall score that is based on this questionnaire.
	\|-		\|-
	!used_in_round		!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.		\|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		!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.		\|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		!topic_id
			\|int
	\|If this field is non-null, then this rubric is used only to review this particular topic.		\|If this field is non-null, then this rubric is used only to review this particular topic.
	\|-		\|-
	!duty_id		!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).		\|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).
	\|-		\|-

Admin: /* Assignments Questionnaire Variable Documentation */

2024-11-24T00:59:44Z

Assignments Questionnaire Variable Documentation

← Older revision		Revision as of 00:59, 24 November 2024
Line 11:		Line 11:
	!questionnaire_id		!questionnaire_id
	\|int(11)		\|int(11)
	\|This references ~~the~~ questionnaire id in ~~the questionnaire~~		\|This references a questionnaire that is used in t he assignment
	\|-		\|-
	!assignment_id		!assignment_id
	\|int(11)		\|int(11)
	\|This references the ~~assignment_id~~ in the ~~assignment~~		\|This references the assignment in which the questionnaire is used
	\|}		\|-
			!notification_limit
			\|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
			\|Gives the percentage of the contributor's overall score that is based on this questionnaire.
			\|-
			!used_in_round
			\|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
			\|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
			\|If this field is non-null, then this rubric is used only to review this particular topic.
			\|-
			!duty_id
			\|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 ==		== E/R diagram for Parents Tables ==

Psinha: /* E/R diagram for Parents Tables */

2018-04-23T01:45:19Z

E/R diagram for Parents Tables

← Older revision		Revision as of 01:45, 23 April 2018
Line 21:		Line 21:
	Tables referred by the Assignment Badges Table as Foreign Key Relationship.		Tables referred by the Assignment Badges Table as Foreign Key Relationship.

	[[File:~~assignments_questionnaire_imported~~.png]]		[[File:assignments_questionnaires_imported.png]]

	== E/R diagram for Child Tables ==		== E/R diagram for Child Tables ==

Psinha at 01:44, 23 April 2018

2018-04-23T01:44:58Z

← Older revision		Revision as of 01:44, 23 April 2018
Line 1:		Line 1:
	'''Deprecated'''		'''Deprecated'''
			== Assignments Questionnaire Variable Documentation ==

	{\| class="wikitable"		{\| class="wikitable"
Line 13:		Line 14:
	\|-		\|-
	!assignment_id		!assignment_id
	\|int(11)		\|int(11)

	\|This references the assignment_id in the assignment		\|This references the assignment_id in the assignment
	\|}		\|}

			== E/R diagram for Parents Tables ==
			Tables referred by the Assignment Badges Table as Foreign Key Relationship.

			[[File:assignments_questionnaire_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.

Rkyadav: 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..."

2016-05-17T14:47:08Z

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..."

New page

'''Deprecated'''

{| class="wikitable"
!Field Name !!Type !!Description
|-
!id
|int(11)
|The unique record id
|-
!questionnaire_id
|int(11)
|This references the questionnaire id in the questionnaire
|-
!assignment_id
|int(11)

|This references the assignment_id in the assignment
|}

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.