Participants: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 24: | Line 24: | ||
!parent_id | !parent_id | ||
|INT(10) | |INT(10) | ||
|unique id referring to parent | |unique id referring to parent assignment or course | ||
|- | |- | ||
!submitted_at | !submitted_at | ||
Revision as of 01:22, 5 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 |
E/R diagram for Parents Tables
Tables referred by the Participants Table as Foreign Key Relationship.
Back to Database Tables Main page.