Participants: Difference between revisions
Jump to navigation
Jump to search
(Created page with "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] ==Particip...") |
No edit summary |
||
| Line 60: | Line 60: | ||
|} | |} | ||
== E/R diagram for Parents Tables == | |||
Tables referred by the Assignment Table as Foreign Key Relationship. | |||
[[File:participants_eer.png]] | |||
Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page. | Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page. | ||
Revision as of 21:34, 25 April 2018
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.