Participants: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
No edit summary
 
(18 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Users associated with either a [http://wiki.expertiza.ncsu.edu/index.php/Courses_table course] or an [http://wiki.expertiza.ncsu.edu/index.php/Assignments assignment]
Users associated with either a [http://wiki.expertiza.ncsu.edu/index.php/Courses_table course] or an [http://wiki.expertiza.ncsu.edu/index.php/Assignments assignment]


==Participants variable documentation==
==Participants variable documentation (Reimplementation)==


{| class="wikitable"  
{| class="wikitable" 
!Field Name !!Type !!Description
!Field Name !!Type !!Description 
|-  
|-
!id 
!user_id
|int(11)
|INT(10)
|The unique record id
|unique id referring to the user
|-  
|-
!submit_allowed 
!id 
|tinyint(1)
|INT(10)
|true if participant is allowed to submit to this assignment
|unique identifier for the person participating
|-  
|-
!review_allowed 
!can_submit
|tinyint(1) 
|BIT
|true if the participant is allowed to review.
|bit to identify whether the person can submit or not
|-  
|-
!user_id 
!can_review
|int(11)
|BIT
|User id of the participant
|bit to identify whether the person can review or not
|-  
|-
!parent_id 
!parent_id
|int(11)
|INT(10)
|Id of corresponding assignment for which the user is a participant in.
|unique id referring to parent assignment or course
|-  
|-
!directory_num 
!OK_to_show
|int(11)
|BIT
|number of user's submission directory for this assignment
|this bit tells whether the instructor can use the work that the student has submitted later on (formerly permission_granted).
|-  
|-
!submitted_at 
!grade
|datetime 
|FLOAT
|time that original version was submitted, i.e., time that the _last_ file was submitted to that version # note that lateness of REsubmissions is tracked in the resubmission_times table. The lateness of resubmissions is cumulative; e.g., if you're late by 2 days on the first resubmission and late by 1 day on the second, you're late by 3 days on resubmissions overall
|Grade allotted for the submission after evaluation
|-  
|-
!topic_id
!type
|int(11)
|VARCHAR(255)
|the topic, if any, that the participant selected for this assignment
|either CourseParticipant or AssignmentParticipant
|-  
|-
!permission_granted 
!handle
|tinyint(1)
|VARCHAR(255)
|whether user has granted permission to "publish" this work
|the handle that the user wants to be known by in this assignment
|-  
|-
!penalty_accumulated 
!can_take_quiz
|int(10)
|BIT
|total penalty accumulated since the first submission deadline in minutes
|this bit signifies whether the participant can take a quiz on the work they are reviewing
|-  
|-
!submitted_hyperlink 
!can_mentor
|text 
|BIT
|URL of the submitted homework
|Indicates whether the participant can act as a mentor.
|-  
|}
!grade  
 
|float 
==Participants variable documentation (2023 version)==
|the overall grade of the student
 
|-  
{| class="wikitable" 
!type  
!Field Name !!Type !!Description 
|varchar(255)
|-
 
!id 
|type of participant, either an AssignmentParticipant or a CourseParticipant
|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 ==
== E/R diagram for Parents Tables ==

Latest revision as of 03:35, 9 December 2025

Users associated with either a course or an assignment

Participants variable documentation (Reimplementation)

Field Name Type Description 
user_id INT(10) unique id referring to the user
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
parent_id INT(10) unique id referring to parent assignment or course
OK_to_show BIT this bit tells whether the instructor can use the work that the student has submitted later on (formerly permission_granted).
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
can_take_quiz BIT this bit signifies whether the participant can take a quiz on the work they are reviewing
can_mentor BIT Indicates whether the participant can act as a mentor.

Participants variable documentation (2023 version)

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.

Retrieved from "https://wiki.expertiza.ncsu.edu/index.php?title=Participants&oldid=167469"