Due dates: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
(Created page with "{| class="wikitable" !Field Name !!Type !!Description |- !due_at |datetime |Deadline for submission |- !deadline_type_id |int(11) |whether a submission deadline, a ...")
 
 
(9 intermediate revisions by 3 users not shown)
Line 1: Line 1:
The Due Dates table gives information regarding the due dates associated to each of the assignment.
== Due Dates Variable Documentation ==
{| class="wikitable"  
{| class="wikitable"  
!Field Name !!Type !!Description  
!Field Name !!Type !!Description  
|-
!id 
|int(11) 
|Unique ID for each Due Date record
|-  
|-  
!due_at   
!due_at   
Line 10: Line 17:
|whether a submission deadline, a review deadline, etc.
|whether a submission deadline, a review deadline, etc.
|-  
|-  
!assignment_id    
!parent_id    
|int(11)   
|int(11)   
|the assignment that this due date pertains to  
|the assignment that the deadline is related to
|-
!late_policy_id 
|int(11) 
|specifies how many points/percent taken off for a particular amt. of lateness
|-  
|-  
!submission_allowed_id   
!submission_allowed_id   
Line 24: Line 27:
!review_allowed_id   
!review_allowed_id   
|int(11)   
|int(11)   
|this is "OK", "Late" or "No", depending on whether reviewing is allowed before this due date
|this is "No", "Late" or "OK", depending on whether reviewing is allowed before this due date
|-  
|-  
!resubmission_allowed_id    
!review_of_review_allowed_id    
|int(11)   
|int(11)   
|controls whether a version submitted since last submission deadline may be resubmitted now  ''As of Summer 2013, resubmission_allowed has been removed, but old code may still refer to it.  Now, resubmission is allowed whenever submission is allowed.''
|this is "OK", "Late" or "No", depending on whether meta-reviewing is allowed before this due date
|-  
|-  
!rereview_allowed_id    
!round 
|int(11) 
|Number of the review round to which this due date pertains
|-
!flag 
|tinyint(1) 
|Not clear what this is.  It is zero in all due dates except some between 2010/11/15 and 2011/05/25.
|-
!threshold    
|int(11)   
|int(11)   
|controls whether a version submitted since last review deadline may be reviewed now  ''As of Summer 2013, rereview_allowed has been removed, but old code may still refer to it.  Now, "rereview" is allowed whenever reviewing is allowed.''
|How many hours before the due date a reminder is sent to participants
|-  
|-  
!review_of_review_allowed_id    
!delayed_job_id
|int(11) 
|ID of the delayed job, presumably the job that sends reminders of this due date.
|-
!deadline_name 
|varchar(255) 
|Name of the deadline.  This is either NULL or the empty string in all deadlines.
|-
!description_url 
|varchar(255) 
|URL of the description
|-
!quiz_allowed_id 
|int(11) 
|ID of the quiz associated to the Due Date.
|-
!teammate_review_allowed_id    
|int(11)   
|int(11)   
|controls whether a version submitted
|The ID of the teammate whose review needs to be done.
|-  
|-  
!round    
!type    
|int(11)   
|int(11)   
|Number of review rounds
|Type of the Due Date.
|}
|}
== E/R diagram for Parents Tables ==
Tables referred by the Due Date Table as Foreign Key Relationship.
[[File:due_dates_imported.png]]
== E/R diagram for Child Tables ==
No Tables refer the Due Date Table as Foreign Key Relationship.




Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.
Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Latest revision as of 05:05, 18 February 2023

The Due Dates table gives information regarding the due dates associated to each of the assignment.

Due Dates Variable Documentation

Field Name Type Description
id int(11) Unique ID for each Due Date record
due_at datetime Deadline for submission
deadline_type_id int(11) whether a submission deadline, a review deadline, etc.
parent_id int(11) the assignment that the deadline is related to
submission_allowed_id int(11) this is "OK", "Late" or "No", depending on whether submission is allowed before this due date
review_allowed_id int(11) this is "No", "Late" or "OK", depending on whether reviewing is allowed before this due date
review_of_review_allowed_id int(11) this is "OK", "Late" or "No", depending on whether meta-reviewing is allowed before this due date
round int(11) Number of the review round to which this due date pertains
flag tinyint(1) Not clear what this is. It is zero in all due dates except some between 2010/11/15 and 2011/05/25.
threshold int(11) How many hours before the due date a reminder is sent to participants
delayed_job_id int(11) ID of the delayed job, presumably the job that sends reminders of this due date.
deadline_name varchar(255) Name of the deadline. This is either NULL or the empty string in all deadlines.
description_url varchar(255) URL of the description
quiz_allowed_id int(11) ID of the quiz associated to the Due Date.
teammate_review_allowed_id int(11) The ID of the teammate whose review needs to be done.
type int(11) Type of the Due Date.

E/R diagram for Parents Tables

Tables referred by the Due Date Table as Foreign Key Relationship.

E/R diagram for Child Tables

No Tables refer the Due Date Table as Foreign Key Relationship.



Back to Database Tables Main page.

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