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 ...")
 
No edit summary
Line 1: Line 1:
== 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 16:
|whether a submission deadline, a review deadline, etc.
|whether a submission deadline, a review deadline, etc.
|-  
|-  
!assignment_id    
!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)   
|int(11)   
|the assignment that this due date pertains to
|this is "OK", "Late" or "No", depending on whether reviewing is allowed before this due date
|-  
|-  
!late_policy_id    
!review_of_review_allowed_id    
|int(11)   
|int(11)   
|specifies how many points/percent taken off for a particular amt. of lateness
|this is "OK", "Late" or "No", depending on whether reviewing of the review is allowed before this due date
|-  
|-  
!submission_allowed_id    
!round    
|int(11)   
|int(11)   
|this is "OK", "Late" or "No", depending on whether submission is allowed before this due date
|Number of review rounds
|-
!flag 
|tinyint(1) 
|Boolean Flag
|-  
|-  
!review_allowed_id    
!threshold    
|int(11)   
|int(11)   
|this is "OK", "Late" or "No", depending on whether reviewing is allowed before this due date
|Threshold of the Due Date
|-  
|-  
!resubmission_allowed_id 
!delayed_job_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.''
|ID of the delayed job.
|-  
|-  
!rereview_allowed_id    
!deadline_name 
|varchar(255) 
|Name of the Deadline
|-
!description_url 
|varchar(255) 
|URL of the description
|-
!quiz_allowed_id    
|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.''
|ID of the quiz associated to the Due Date.
|-  
|-  
!review_of_review_allowed_id    
!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.

Revision as of 01:15, 23 April 2018

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.
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 "OK", "Late" or "No", 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 reviewing of the review is allowed before this due date
round int(11) Number of review rounds
flag tinyint(1) Boolean Flag
threshold int(11) Threshold of the Due Date
delayed_job_id int(11) ID of the delayed job.
deadline_name varchar(255) Name of the Deadline
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=116762"