Assignments

The Assignments table contains one record for each assignment created by an instructor or administrator.

Assignment Variable Documentation

Field Name	Type	Description
id	int(11)	This object's unique ID value. One per object.
created_at	datetime	The date/time stamp when this record was created
updated_at	datetime	The date/time stamp when this record was last modified
name	varchar(255)	The name given to this assignment by the instructor/administrator who created it
directory_path	varchar(255)	If this is an assignment to which files are being submitted, this is the first part of the directory path for the submissions. If this is a wiki assignment, it is the base URL for wiki pages submitted by the creators
submitter_count	int(10)	Number of creators who have submitted so far to this assignment
course_id	int(11)	ID in the Courses table of the course with which this assignment is associated
instructor_id	int(11)	ID of a instructor who created the assignment
private	tinyint(1)	whether assignment is visible to other instructors
num_reviews	int(11)	number of reviews done by a student for this assignment
num_review_of_reviews	int(10)	number of reviews of reviews done by a student for this assignment
num_review_of_reviewers	int(11)	number of reviewers who have reviewed the assignment.
reviews_visible_to_all	tinyint(1)	if false, other reviewers can't see this reviewer's review.
num_reviewers	int(10)	Number of reviewers.
spec_location	text	url of the assignment.
max_team_size	int(11)	Maximum number of participants allowed on the team.
staggerred_deadline	tinyint(1)	Indicating whether deadlines are staggered or not *************
allow_suggestions	tinyint(1)	Indicating whether participants in an assignment with topics may suggest additional topics for the instructor to approve.
days_between_submissions	int(11)	Number of Days available between submissions *************
review_assignment_strategy	varchar(12)
review_topic_threshold	int(11)	***********************************
copy_flag	tinyint(1)	Whether the assignment has a copy or not. *************
rounds_of_reviews	int(11)	Total number of rounds of reviews done for the assignment *************
microtask	tinyint(1)	Indicating whether this is a microtask assignment, i.e., if it has topics that are worth varying amounts of credit, and may be selected by students.
require_quiz	tinyint(1)	Indicating whether the assignment requires a quiz or not. *************
num_quiz_questions	int(11)	Total number of questions present for the quiz. *************
is_coding_assignment	tinyint(1)	Indicating whether whether the given assignment is a coding assignment or not *************
is_intelligent	tinyint(1)	Indicates whether topics are to be bid on, and then the "intelligent assignment" algorithm will assign teams to topics *************
calculate_penalty	tinyint(1)	Indicating whether penalty needs to be calculated for the given assignment. *************
late_policy_id	int(11)	ID in the ******late policy table***** *************. Indicating which late policy is applied here.
is_penalty_calculated	tinyint(1)	Indicating whether the penalty for the assignment is calculated or not. *************
max_bids	int(11)	Total amount of bids given for this assignment. *************
show_teammate_reviews	tinyint(1)	Indicating whether teammate reviews are shown or not. *************
availability_flag	tinyint(1)	Indicating whether the given assignment is available or not. *************
use_bookmark	tinyint(1)	Indicating whether bookmarks are used or not. *************
can_review_same_topic	tinyint(1)	Indicating whether a reviewer can review the same topic again. *************
can_choose_topic_to_review	tinyint(1)	Indicating whether a reviewer can choose a topic to review *************
is_calibrated	tinyint(1)	Indicating whether the assignment is calibrated or not. *************
is_selfreview_enabled	tinyint(1)	Indicating whether an author can review his/her work. *************
reputation_algorithm	varchar(12)	This field gives us the information of the reputation algorithm used for this assignment. *************
is_anonymous	tinyint(1)	Indicating whether whether the reviewer information is anonymous or not. *************
num_reviews_required	int(11)	Total number of reviews required for this assignment. *************
num_metareviews_required	int(11)	Total number of metareviews required for this assignment. *************
num_metareviews_allowed	int(11)	Total number of metareviews allowed for this assignment. *************
num_reviews_allowed	int(11)	Total number of reviews allowed for this assignment. *************
simicheck	int(11)	Similarity Check between assignments. *************
simicheck_threshold	int(11)	Similarity check threshold value for the given assignment. *************

E/R diagram for Parents Tables

Tables referred by the Assignment Table as Foreign Key Relationship.

E/R diagram for Child Tables

Tables which refer the Assignment Table as Foreign Key Relationship.

Back to the database documentation