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