Participants: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
 
(6 intermediate revisions by the same user not shown)
Line 32: Line 32:
!permission_granted
!permission_granted
|BIT
|BIT
|the on or off bit tells whether the permission is granted or not
|this bit tells whether the instructor can use the work that the student has submitted later on.
|-
|-
!penalty_accumulated
!penalty_accumulated
Line 44: Line 44:
!type
!type
|VARCHAR(255)
|VARCHAR(255)
|
|either CourseParticipant or AssignmentParticipant
|-
|-
!handle
!handle
|VARCHAR(255)
|VARCHAR(255)
|the handle used during submission
|the handle that the user wants to be known by in this assignment
|-
!time_stamp
!time_stamp
|DATETIME
|DATETIME
Line 60: Line 59:
!duty
!duty
|VARCHAR(255)
|VARCHAR(255)
|the "role" of this person on their team, e.g., tester
|the "role" of this person on their team, e.g., tester.  Used only when roles are assigned to team members.
|-
|-
!can_take_quiz
!can_take_quiz
|BIT
|BIT
|this bit signifies whether the participant can take quiz or not
|this bit signifies whether the participant can take a quiz on the work they are reviewing
|
|-
|Hamer
|FLOAT
|the reputation of this participant using the Hamer algorithm
|-
|-
!hidden
|Lauw
|BIT
|FLOAT
|if true, the assignment will not show up in the reviewer's assignment list.  (If the reviewer is an instructor, (s)he can review any submission, even if not a (formal) participant.)
|the reputation of this participant using the Lauw algorithm
|}
|}



Latest revision as of 17:34, 15 February 2023

Users associated with either a course or an assignment

Participants variable documentation

Field Name Type Description
id INT(10) unique identifier for the person participating
can_submit BIT bit to identify whether the person can submit or not
can_review BIT bit to identify whether the person can review or not
user_id INT(10) unique id referring to the user
parent_id INT(10) unique id referring to parent assignment or course
submitted_at DATETIME Date and Time of the submission made
permission_granted BIT this bit tells whether the instructor can use the work that the student has submitted later on.
penalty_accumulated INT UNSIGNED
grade FLOAT Grade allotted for the submission after evaluation
type VARCHAR(255) either CourseParticipant or AssignmentParticipant
handle VARCHAR(255) the handle that the user wants to be known by in this assignment time_stamp DATETIME
digital_signature TEXT to record what was the evaluation
duty VARCHAR(255) the "role" of this person on their team, e.g., tester. Used only when roles are assigned to team members.
can_take_quiz BIT this bit signifies whether the participant can take a quiz on the work they are reviewing
Hamer FLOAT the reputation of this participant using the Hamer algorithm
Lauw FLOAT the reputation of this participant using the Lauw algorithm

E/R diagram for Parents Tables

Tables referred by the Participants Table as Foreign Key Relationship.

Back to Database Tables Main page.