Participants: Difference between revisions

From Expertiza_Wiki
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.