Participants
Users associated with either a course or an assignment
Participants variable documentation
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | The unique record id |
| submit_allowed | tinyint(1) | true if participant is allowed to submit to this assignment |
| review_allowed | tinyint(1) | true if the participant is allowed to review. |
| user_id | int(11) | User id of the participant |
| parent_id | int(11) | Id of corresponding assignment for which the user is a participant in. |
| directory_num | int(11) | number of user's submission directory for this assignment |
| submitted_at | datetime | 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 |
| topic_id | int(11) | the topic, if any, that the participant selected for this assignment |
| permission_granted | tinyint(1) | whether user has granted permission to "publish" this work |
| penalty_accumulated | int(10) | total penalty accumulated since the first submission deadline in minutes |
| submitted_hyperlink | text | URL of the submitted homework |
| grade | float | the overall grade of the student |
| type | varchar(255) | type of participant, either an AssignmentParticipant or a CourseParticipant |
E/R diagram for Parents Tables
Tables referred by the Assignment Table as Foreign Key Relationship.
Back to Database Tables Main page.