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. |
| review_strategy_id | int(11) | the review strategy, e.g., "rubric", "ranking" |
| mapping_strategy_id | int(11) | the review-mapping strategy, e.g., "static", "dynamic" |
| review_questionnaire_id | int(11) | This references the questionnaire table which and the id of the questionnaire in that table. It is a foreign key. |
| review_of_review_questionnaire_id | int(11) | This references the questionnaire table and the questionnaire id. |
| teammate_review_questionnaire_id | int(10) | This references the questionnaire table and the questionnaire id. |
| review_weight | float | the percentage that reviews count for; the balance of grade depends on reviews of reviews |
| reviews_visible_to_all | tinyint(1) | if false, other reviewers can't see this reviewer's review |
| team_assignment | tinyint(1) | It's a flag to indicate whether it is a team assignment or individual assignment |
| wiki_type_id | int(11) | id of wiki assignment type |
| require_signup | tinyint(1) | if true, users need to sign up through Shimmer before submitting; if false, everyone in course may submit; if assignment not in course, default is that no one may submit. |
| num_reviewers | int(10) | Number of reviewers. |
| spec_location | text | url of the assignment |
| author_feedback_questionnaire_id | int(11) | This references the questionnaire table and the questionnaire id. |
| max_team_size | int(11) | Number of people in the team. |
Back to the database documentation