Assignments: Difference between revisions
Jump to navigation
Jump to search
| (13 intermediate revisions by 2 users not shown) | |||
| Line 32: | Line 32: | ||
!course_id | !course_id | ||
|int(11) | |int(11) | ||
|ID in the [http:// | |ID in the [http://wiki.expertiza.ncsu.edu/index.php/Courses_table Courses] table of the course with which this assignment is associated | ||
|- | |- | ||
!instructor_id | !instructor_id | ||
| Line 68: | Line 68: | ||
!max_team_size | !max_team_size | ||
|int(11) | |int(11) | ||
| | |Maximum number of participants allowed on the team. | ||
|- | |- | ||
!staggerred_deadline | !staggerred_deadline | ||
| Line 76: | Line 76: | ||
!allow_suggestions | !allow_suggestions | ||
|tinyint(1) | |tinyint(1) | ||
|Indicating whether | |Indicating whether participants in an assignment with topics may suggest additional topics for the instructor to approve. | ||
|- | |- | ||
!days_between_submissions | !days_between_submissions | ||
|int( | |int(11) | ||
|Number of Days available between submissions ************* | |Number of Days available between submissions ************* | ||
|- | |- | ||
!review_assignment_strategy | !review_assignment_strategy | ||
|varchar(12) | |varchar(12) | ||
| | | | ||
|- | |- | ||
!review_topic_threshold | !review_topic_threshold | ||
|int( | |int(11) | ||
|*********************************** | |*********************************** | ||
|- | |- | ||
| Line 95: | Line 95: | ||
|- | |- | ||
!rounds_of_reviews | !rounds_of_reviews | ||
|int( | |int(11) | ||
|Total number of rounds of reviews done for the assignment ************* | |Total number of rounds of reviews done for the assignment ************* | ||
|- | |- | ||
!microtask | !microtask | ||
|tinyint(1) | |tinyint(1) | ||
|Indicating whether | |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 | !require_quiz | ||
| Line 107: | Line 107: | ||
|- | |- | ||
!num_quiz_questions | !num_quiz_questions | ||
|int( | |int(11) | ||
|Total number of questions present for the quiz. ************* | |Total number of questions present for the quiz. ************* | ||
|- | |- | ||
| Line 116: | Line 116: | ||
!is_intelligent | !is_intelligent | ||
|tinyint(1) | |tinyint(1) | ||
| | |Indicates whether topics are to be bid on, and then the "intelligent assignment" algorithm will assign teams to topics ************* | ||
|- | |- | ||
!calculate_penalty | !calculate_penalty | ||
| Line 123: | Line 123: | ||
|- | |- | ||
!late_policy_id | !late_policy_id | ||
|int( | |int(11) | ||
|ID in the ******late policy table***** *************. Indicating which late policy is applied here. | |ID in the ******late policy table***** *************. Indicating which late policy is applied here. | ||
|- | |- | ||
| Line 131: | Line 131: | ||
|- | |- | ||
!max_bids | !max_bids | ||
|int( | |int(11) | ||
|Total amount of bids given for this assignment. ************* | |Total amount of bids given for this assignment. ************* | ||
|- | |- | ||
| Line 171: | Line 171: | ||
|- | |- | ||
!num_reviews_required | !num_reviews_required | ||
|int( | |int(11) | ||
|Total number of reviews required for this assignment. ************* | |Total number of reviews required for this assignment. ************* | ||
|- | |- | ||
!num_metareviews_required | !num_metareviews_required | ||
|int( | |int(11) | ||
|Total number of metareviews required for this assignment. ************* | |Total number of metareviews required for this assignment. ************* | ||
|- | |- | ||
!num_metareviews_allowed | !num_metareviews_allowed | ||
|int( | |int(11) | ||
|Total number of metareviews allowed for this assignment. ************* | |Total number of metareviews allowed for this assignment. ************* | ||
|- | |- | ||
!num_reviews_allowed | !num_reviews_allowed | ||
|int( | |int(11) | ||
|Total number of reviews allowed for this assignment. ************* | |Total number of reviews allowed for this assignment. ************* | ||
|- | |- | ||
!simicheck | !simicheck | ||
|int( | |int(11) | ||
| | |Similarity Check between assignments. ************* | ||
|- | |- | ||
!simicheck_threshold | !simicheck_threshold | ||
|int( | |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. | |||
[[File:assignment_imported.png]] | |||
== E/R diagram for Child Tables == | == E/R diagram for Child Tables == | ||
Tables which refer the Assignment Table as Foreign Key Relationship. | |||
[[File:assignment_exported.png]] | [[File:assignment_exported.png]] | ||
Back to the [[Documentation_on_Database_Tables|database documentation]] | Back to the [[Documentation_on_Database_Tables|database documentation]] | ||
Latest revision as of 14:17, 1 April 2021
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