Assignment questionnaires: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
No edit summary
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 ==

Revision as of 00:38, 23 April 2018

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.
used_in_round tinyint(1) Indicating whether a dropdown is present or not.

E/R diagram for Child Tables

The following image shows which tables have referenced the Assignment_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 database documentation