Due dates: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 7: | Line 7: | ||
!id | !id | ||
|int(11) | |int(11) | ||
|Unique ID for each Due Date record | |Unique ID for each Due Date record | ||
|- | |- | ||
!due_at | !due_at | ||
| Line 16: | Line 16: | ||
|int(11) | |int(11) | ||
|whether a submission deadline, a review deadline, etc. | |whether a submission deadline, a review deadline, etc. | ||
|- | |||
!parent_id | |||
|int(11) | |||
|the assignment that the deadline is related to | |||
|- | |- | ||
!submission_allowed_id | !submission_allowed_id | ||
Revision as of 00:10, 5 December 2019
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 "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.