Participants: Difference between revisions
Jump to navigation
Jump to search
| (9 intermediate revisions by the same user not shown) | |||
| Line 32: | Line 32: | ||
!permission_granted | !permission_granted | ||
|BIT | |BIT | ||
| | |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 | |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. 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 | |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 | ||
|} | |} | ||
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.