Participants

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	this bit tells whether the instructor can use the work that the student has submitted later on.
penalty_accumulated	INT UNSIGNED
grade	FLOAT	Grade allotted for the submission after evaluation
type	VARCHAR(255)	either CourseParticipant or AssignmentParticipant
handle	VARCHAR(255)	the handle that the user wants to be known by in this assignment	time_stamp	DATETIME
digital_signature	TEXT	to record what was the evaluation
duty	VARCHAR(255)	the "role" of this person on their team, e.g., tester. Used only when roles are assigned to team members.
can_take_quiz	BIT	this bit signifies whether the participant can take a quiz on the work they are reviewing
Hamer	FLOAT	the reputation of this participant using the Hamer algorithm
Lauw	FLOAT	the reputation of this participant using the Lauw algorithm

E/R diagram for Parents Tables

Tables referred by the Participants Table as Foreign Key Relationship.

Back to Database Tables Main page.