Due dates

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)	this is "OK", "Late" or "No", depending on whether teammate review is allowed before this due date
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.