Assignment questionnaires: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
 
(3 intermediate revisions by one other user not shown)
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.
|}
|}
== 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 Assignments_questionnaires Table.
Tables which refer the Assignment_questionnaires Table as Foreign Key Relationship.


== E/R diagram for Parent Tables ==
[[File:assignment_questionnaire_imported.png]]
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]]

Latest revision as of 18:21, 27 May 2020

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