Assignment questionnaires - Revision history

Rtantry2: /* Assignment Questionnaires variable documentation */

2025-12-09T03:03:19Z

Assignment Questionnaires variable documentation

@@ Line 1: / Line 1: @@
 The assignment_questionnaires table defines the joins between a [[questionnaires|questionnaire]] and an [[assignments|assignment]]. It is also used to associate default limits for the notifications an instructor receives.
-==Assignment Questionnaires variable documentation==
+==Assignment Questionnaires variable documentation (Reimplementation)==
 {| class="wikitable"
 !Field Name !!Type !!Description
 |-
 !id

Svshingt at 18:21, 27 May 2020

2020-05-27T18:21:21Z

← Older revision		Revision as of 18:21, 27 May 2020
Line 33:		Line 33:
	\|Questionnaire used in which particular round.		\|Questionnaire used in which particular round.
	\|-		\|-
	!~~used_in_round~~		!dropdown
	\|tinyint(1)		\|tinyint(1)
	\|Indicating whether a dropdown is present or not.		\|Indicating whether a dropdown is present or not.

Psinha at 00:42, 23 April 2018

2018-04-23T00:42:40Z

← Older revision		Revision as of 00:42, 23 April 2018
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 ==
	~~The following image shows~~ which ~~tables have referenced~~ the Assignment_questionnaires Table.		Tables which refer the Assignment_questionnaires Table as Foreign Key Relationship.

	[[File:assignment_questionnaire_imported.png]]		[[File:assignment_questionnaire_imported.png]]

	~~== E/R diagram for Parent Tables ==~~
	~~The table Assignment_questionnaire has not referred to any other table.~~


	Back to the [[Documentation_on_Database_Tables\|database documentation]]		Back to the [[Documentation_on_Database_Tables\|database documentation]]

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

2018-04-23T00:40:31Z

E/R diagram for Parent Tables

← Older revision		Revision as of 00:40, 23 April 2018
Line 44:		Line 44:

	== E/R diagram for Parent Tables ==		== E/R diagram for Parent Tables ==
	The ~~following image shows which tables have been~~ referred ~~by the Assignments_questionnaires Table~~.		The table Assignment_questionnaire has not referred to any other table.


	Back to the [[Documentation_on_Database_Tables\|database documentation]]		Back to the [[Documentation_on_Database_Tables\|database documentation]]

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

2018-04-23T00:38:05Z

E/R diagram for Child Tables

← Older revision		Revision as of 00:38, 23 April 2018
Line 39:		Line 39:

	== E/R diagram for Child Tables ==		== E/R diagram for Child Tables ==
	The following image shows which tables have referenced the ~~Assignments_questionnaires~~ Table.		The following image shows which tables have referenced the Assignment_questionnaires Table.

			[[File:assignment_questionnaire_imported.png]]

	== E/R diagram for Parent Tables ==		== E/R diagram for Parent Tables ==

Psinha at 00:31, 23 April 2018

2018-04-23T00:31:43Z

← Older revision		Revision as of 00:31, 23 April 2018
Line 37:		Line 37:
	\|Indicating whether a dropdown is present or not.		\|Indicating whether a dropdown is present or not.
	\|}		\|}

			== E/R diagram for Child Tables ==
			The following image shows which tables have referenced the Assignments_questionnaires Table.

			== E/R diagram for Parent Tables ==
			The following image shows which tables have been referred by the Assignments_questionnaires Table.


	Back to the [[Documentation_on_Database_Tables\|database documentation]]		Back to the [[Documentation_on_Database_Tables\|database documentation]]

Psinha: /* Assignment Questionnaires variable documentation */

2018-04-23T00:24:51Z

Assignment Questionnaires variable documentation

← Older revision		Revision as of 00:24, 23 April 2018
Line 28:		Line 28:
	\|int(11)		\|int(11)
	\|A percentage that the [[questionnaires\|questionnaire]] contributes to the overall score. When both assignment_id and questionnaire_id are null, this relationship defines the defaults set by the instructor.		\|A percentage that the [[questionnaires\|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.
	\|}		\|}

	Back to the [[Documentation_on_Database_Tables\|database documentation]]		Back to the [[Documentation_on_Database_Tables\|database documentation]]

Rkyadav: Created page with "The assignment_questionnaires table defines the joins between a questionnaire and an assignment. It is also used to associate default limits fo..."

2016-05-17T14:34:32Z

Created page with "The assignment_questionnaires table defines the joins between a questionnaire and an assignment. It is also used to associate default limits fo..."

New page

The assignment_questionnaires table defines the joins between a [[questionnaires|questionnaire]] and an [[assignments|assignment]]. It is also used to associate default limits for the notifications an instructor receives.
==Assignment Questionnaires variable documentation==

{| class="wikitable"
!Field Name !!Type !!Description
|-
!id
|int(11)
|The unique record id
|-
!assignment_id
|int(11)
|The ID of the [[assignments|assignment]] in this relationship. A null value is used to define the default limits
|-
!questionnaire_id
|int(11)
|The ID of the [[questionnaires|questionnaire]] in this relationship. A null value is used to define the default limits
|-
!user_id
|int(11)
|The ID of the [[users|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 [[questionnaires|questionnaire]] contributes to the overall score. When both assignment_id and questionnaire_id are null, this relationship defines the defaults set by the instructor.
|}

Back to the [[Documentation_on_Database_Tables|database documentation]]