Assignments: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
 
(16 intermediate revisions by 3 users not shown)
Line 1: Line 1:
The Assignments table contains one record for each assignment created by an [[users|instructor]] or [[users|administrator]].
The Assignments table contains one record for each assignment created by an [[users|instructor]] or [[users|administrator]].


==Assignment Variable Documentation==
== Current Assignment Variable Documentation (Reimplementation) ==
<div style="background-color: #e6f7ff; border: 1px solid #0077b3; padding: 10px; margin-bottom: 20px;">
'''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.
</div>


{| class="wikitable"  
{| class="wikitable" 
!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 [http://wiki.expertiza.ncsu.edu/index.php/Courses_table 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) ==
 
{| class="wikitable" 
!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 [http://wiki.expertiza.ncsu.edu/index.php/Courses_table 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.
 
[[File:assignment_imported.png]]
 
== E/R diagram for Child Tables ==
Tables which refer the Assignment Table as Foreign Key Relationship.
 
[[File:assignment_exported.png]]
 
<br />
<br />
<hr />
 
= ARCHIVED: Previous Schema =
<div style="background-color: #f9f9f9; border: 1px solid #aaa; padding: 10px;">
'''Deprecated:''' The table structure below represents the schema prior to the recent updates. It is retained here for historical reference.
</div>
 
{| class="wikitable mw-collapsible mw-collapsed"  
!Field Name !!Type !!Description  
!Field Name !!Type !!Description  
|-  
|-  
Line 32: Line 504:
!course_id   
!course_id   
|int(11)   
|int(11)   
|ID in the [http://wikis.lib.ncsu.edu/index.php/Courses_table Courses] table of the course with which this assignment is associated
|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 540:
!max_team_size  
!max_team_size  
|int(11)   
|int(11)   
|Number of people in the team.
|Maximum number of participants allowed on the team.
|-  
|-  
!staggerred_deadline
!staggered_deadline
|tinyint(1)   
|tinyint(1)   
|Indicating whether deadlines are staggered or not *************
|Indicating whether deadlines are staggered or not *************
Line 76: Line 548:
!allow_suggestions  
!allow_suggestions  
|tinyint(1)   
|tinyint(1)   
|Indicating whether suggestions are allowed or not *************
|Indicating whether participants in an assignment with topics may suggest additional topics for the instructor to approve.
|-  
|-  
!days_between_submissions  
!days_between_submissions  
|int(4)   
|int(11)   
|Number of Days available between submissions *************
|Number of Days available between submissions *************
|-  
|-  
!review_assignment_strategy  
!review_assignment_strategy  
|varchar(12)   
|varchar(12)   
|The review strategy, e.g., "rubric", "ranking"
|
|-  
|-  
!review_topic_threshold
!review_topic_threshold
|int(4)   
|int(11)   
|***********************************
|***********************************
|-  
|-  
Line 95: Line 567:
|-  
|-  
!rounds_of_reviews  
!rounds_of_reviews  
|int(4)   
|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 there is any microtask present. *************
|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 579:
|-  
|-  
!num_quiz_questions  
!num_quiz_questions  
|int(4)   
|int(11)   
|Total number of questions present for the quiz. *************
|Total number of questions present for the quiz. *************
|-  
|-  
Line 116: Line 588:
!is_intelligent  
!is_intelligent  
|tinyint(1)   
|tinyint(1)   
|Indicating whether the assignment is intelligent or not *************
|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 595:
|-  
|-  
!late_policy_id  
!late_policy_id  
|int(4)   
|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 603:
|-  
|-  
!max_bids  
!max_bids  
|int(4)   
|int(11)   
|Total amount of bids given for this assignment. *************
|Total amount of bids given for this assignment. *************
|-  
|-  
Line 171: Line 643:
|-  
|-  
!num_reviews_required   
!num_reviews_required   
|int(4)   
|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(4)   
|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(4)   
|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(4)   
|int(11)   
|Total number of reviews allowed for this assignment. *************
|Total number of reviews allowed for this assignment. *************
|-  
|-  
!simicheck   
!simicheck   
|int(4)   
|int(11)   
|SIMI Check Value. *************
|Similarity Check between assignments. *************
|-  
|-  
!simicheck_threshold
!simicheck_threshold
|int(4)   
|int(11)   
|SIMI check threshold value. *************
|Similarity check threshold value for the given assignment. *************
|}  
|}
 
== E/R diagram for Child Tables ==
[[File:assignment_exported.png]]
 
== E/R diagram for Parents Tables ==
 


Back to the [[Documentation_on_Database_Tables|database documentation]]
Back to the [[Documentation_on_Database_Tables|database documentation]]

Latest revision as of 03:10, 9 December 2025

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

Retrieved from "https://wiki.expertiza.ncsu.edu/index.php?title=Assignments&oldid=167460"