Participants: Difference between revisions
Jump to navigation
Jump to search
| Line 69: | Line 69: | ||
!hidden | !hidden | ||
|BIT | |BIT | ||
| | |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 assignment, even if not a (formal) participant.) | ||
|} | |} | ||
Revision as of 17:28, 13 November 2019
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 | the on or off bit tells whether the permission is granted or not | |
| penalty_accumulated | INT UNSIGNED | ||
| grade | FLOAT | Grade allotted for the submission after evaluation | |
| type | VARCHAR(255) | ||
| handle | VARCHAR(255) | the handle used during submission | |
| time_stamp | DATETIME | ||
| digital_signature | TEXT | to record what was the evaluation | |
| duty | VARCHAR(255) | ||
| can_take_quiz | BIT | this bit signifies whether the participant can take quiz or not | |
| hidden | BIT | 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 assignment, even if not a (formal) participant.) |
E/R diagram for Parents Tables
Tables referred by the Participants Table as Foreign Key Relationship.
Back to Database Tables Main page.