Participants: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| 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 !! | !Field Name !!Type !!Description | ||
|- | |- | ||
!id | !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)== | |||
{| class="wikitable" | |||
!Field Name !!Type !!Description | |||
|- | |||
!id | |||
|INT(10) | |INT(10) | ||
|unique identifier for the person participating | |unique identifier for the person participating | ||
| Line 20: | Line 70: | ||
!user_id | !user_id | ||
|INT(10) | |INT(10) | ||
|unique id referring to the | |unique id referring to the user | ||
|- | |- | ||
!parent_id | !parent_id | ||
| Line 60: | Line 110: | ||
!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 | ||
| Line 66: | Line 116: | ||
|this bit signifies whether the participant can take a quiz on the work they are reviewing | |this bit signifies whether the participant can take a quiz on the work they are reviewing | ||
|- | |- | ||
!Hamer | |||
|FLOAT | |FLOAT | ||
|the reputation of this participant using the Hamer algorithm | |the reputation of this participant using the Hamer algorithm | ||
|- | |- | ||
!Lauw | |||
|FLOAT | |FLOAT | ||
|the reputation of this participant using the Lauw algorithm | |the reputation of this participant using the Lauw algorithm | ||
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.