Assignments
The Assignments table contains one record for each assignment created by an instructor or administrator.
Current Assignment Variable Documentation (Reimplementation)
Structure Update: This table structure was updated in the latest release. Several columns were renamed (e.g., spec_location to URL) and unused columns were removed.
| 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. |
| 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. |
| URL | text | URL of the assignment (formerly spec_location). |
| max_team_size | int(11) | Maximum number of participants allowed on the team. |
| staggered_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. |
| days_between_submissions | int(11) | Number of Days available between submissions. |
| review_assignment_strategy | varchar(12) | Strategy used for assigning reviews. |
| max_reviews_per_submission | int(11) | Maximum number of reviews allowed per submission. |
| review_topic_threshold | int(11) | Threshold for review topics. |
| 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. |
| 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. |
| topics_assigned_by_bidding | tinyint(1) | Indicates whether topics are to be bid on (formerly is_intelligent). |
| 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. |
| is_penalty_calculated | tinyint(1) | Indicating whether the penalty for the assignment is calculated or not. |
| show_teammate_reviews | tinyint(1) | Indicating whether teammate reviews are shown or not. |
| available_to_students | tinyint(1) | Indicating whether the given assignment is available to students (formerly availability_flag). |
| can_bookmark_topics | tinyint(1) | Indicating whether students can bookmark topics (formerly use_bookmark). |
| 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. |
| 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. |
| is_answer_tagging_allowed | tinyint(1) | Indicating if answer tagging is allowed. |
| allow_selecting_additional_reviews_after_1st_round | tinyint(1) | Allows students to take more reviews after the first round. |
| sample_assignment_id | int(11) | ID of a sample assignment used for calibration/example. |
| vary_by_topic | tinyint(1) | Indicates if rubrics/criteria vary by topic. |
| vary_by_round | tinyint(1) | Indicates if rubrics/criteria vary by round. |
| team_reviewing_enabled | tinyint(1) | Indicates if team reviewing is enabled. |
| bidding_for_reviews_enabled | tinyint(1) | Indicates if bidding for reviews is enabled. |
| auto_assign_mentor | tinyint(1) | Indicates if a mentor is automatically assigned. |
| team_members_have_duties | tinyint(1) | Indicates if team members have specific duties (formerly duty_based_assignment). |
| questionnaire_varies_by_duty | tinyint(1) | Indicates if the questionnaire changes based on the duty. |
| enable_pair_programming | tinyint(1) | Indicates if pair programming is enabled for this assignment. |
Current Assignment Variable Documentation (2023 version)
| 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. |
| 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. |
| staggered_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. |
| days_between_submissions | int(11) | Number of Days available between submissions. |
| review_assignment_strategy | varchar(12) | Strategy used for assigning reviews. |
| max_reviews_per_submission | int(11) | Maximum number of reviews allowed per submission. |
| review_topic_threshold | int(11) | Threshold for review topics. |
| 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. |
| 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. |
| 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. |
| is_penalty_calculated | tinyint(1) | Indicating whether the penalty for the assignment is calculated or not. |
| show_teammate_reviews | tinyint(1) | Indicating whether teammate reviews are shown or not. |
| availability_flag | tinyint(1) | Indicating whether the given assignment is available to students. |
| use_bookmark | tinyint(1) | Indicating whether students can bookmark topics. |
| 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. |
| 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. |
| is_answer_tagging_allowed | tinyint(1) | Indicating if answer tagging is allowed. |
| allow_selecting_additional_reviews_after_1st_round | tinyint(1) | Allows students to take more reviews after the first round. |
| sample_assignment_id | int(11) | ID of a sample assignment used for calibration/example. |
| vary_by_topic | tinyint(1) | Indicates if rubrics/criteria vary by topic. |
| vary_by_round | tinyint(1) | Indicates if rubrics/criteria vary by round. |
| team_reviewing_enabled | tinyint(1) | Indicates if team reviewing is enabled. |
| bidding_for_reviews_enabled | tinyint(1) | Indicates if bidding for reviews is enabled. |
| auto_assign_mentor | tinyint(1) | Indicates if a mentor is automatically assigned. |
| duty_based_assignment | tinyint(1) | Indicates if team members have specific duties. |
| questionnaire_varies_by_duty | tinyint(1) | Indicates if the questionnaire changes based on the duty. |
| enable_pair_programming | tinyint(1) | Indicates if pair programming is enabled for this 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.
ARCHIVED: Previous Schema
Deprecated: The table structure below represents the schema prior to the recent updates. It is retained here for historical reference.
| 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. |
| staggered_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. ************* |
Back to the database documentation