Participants: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 5: Line 5:
{| class="wikitable"  
{| class="wikitable"  
!Field Name !!Type !!Description  
!Field Name !!Type !!Description  
|-  
|-
!id  
!id  
|int(11)
|INT(10)
|The unique record id
|unique identifier for the person participating
|-  
|-
!submit_allowed 
!can_submit
|tinyint(1) 
|BIT
|true if participant is allowed to submit to this assignment
|bit to identify whether the person can submit or not
|-  
|-
!review_allowed 
!can_review
|tinyint(1) 
|BIT
|true if the participant is allowed to review.
|bit to identify whether the person can review or not
|-  
|-
!user_id  
!user_id
|int(11)
|INT(10)
|User id of the participant
|unique id referring to the user
|-  
|-
!parent_id  
!parent_id
|int(11)
|INT(10)
|Id of corresponding assignment for which the user is a participant in.
|unique id referring to parent
|-  
|-
!directory_num 
!submitted_at
|int(11) 
|DATETIME
|number of user's submission directory for this assignment
|Date and Time of the submission made
|-  
|-
!submitted_at 
!permission_granted
|datetime 
|BIT
|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
|the on or off bit tells whether the permission is granted or not
|-  
|-
!topic_id
!penalty_accumulated
|int(11) 
|INT UNSIGNED
|the topic, if any, that the participant selected for this assignment
|
|-  
|-
!permission_granted 
!grade
|tinyint(1)
|FLOAT
|whether user has granted permission to "publish" this work
|Grade allotted for the submission after evaluation
|-  
|-
!penalty_accumulated 
!type
|int(10)
|VARCHAR(255)
|total penalty accumulated since the first submission deadline in minutes
|
|-  
|-
!submitted_hyperlink 
!handle
|text 
|VARCHAR(255)
|URL of the submitted homework
|the handle used during submission
|-  
|-
!grade 
!time_stamp
|float 
|DATETIME
|the overall grade of the student
|
|-  
|-
!type 
!digital_signature
|varchar(255)
|TEXT
 
|to record what was the evaluation
|type of participant, either an AssignmentParticipant or a CourseParticipant
|-
!duty
|VARCHAR(255)
|
|-
!can_take_quiz
|BIT
|this bit signifies whether the participant can take quiz or not
|}  
|}  


Revision as of 21:52, 25 April 2018

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

Retrieved from "https://wiki.expertiza.ncsu.edu/index.php?title=Participants&oldid=116945"