Participants

From Expertiza_Wiki
Revision as of 21:34, 25 April 2018 by Agrawa (talk | contribs)
Jump to navigation Jump to search

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.