Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||||||||||||||||||||||||
| course | BIGINT | 19 | 0 |
|
|
|||||||||||||||||||||||||||
| name | VARCHAR | 1333 |
|
|
The name of the instance of the assignment. Displayed at the top of each page. |
|||||||||||||||||||||||||||
| intro | LONGTEXT | 2147483647 | null |
|
|
The description of the assignment. This field is used by feature MOD_INTRO. |
||||||||||||||||||||||||||
| introformat | SMALLINT | 5 | 0 |
|
|
The format of the description field of the assignment. This field is used by feature MOD_INTRO. |
||||||||||||||||||||||||||
| alwaysshowdescription | TINYINT | 3 | 0 |
|
|
If false the assignment intro will only be displayed after the allowsubmissionsfrom date. If true it will always be displayed. |
||||||||||||||||||||||||||
| nosubmissions | TINYINT | 3 | 0 |
|
|
This field is a cache for is_any_submission_plugin_enabled() which allows Moodle pages to distinguish offline assignment types without loading the assignment class. |
||||||||||||||||||||||||||
| submissiondrafts | TINYINT | 3 | 0 |
|
|
If true, assignment submissions will be considered drafts until the student clicks on the submit assignmnet button. |
||||||||||||||||||||||||||
| sendnotifications | TINYINT | 3 | 0 |
|
|
Allows the disabling of email notifications in the assign module. |
||||||||||||||||||||||||||
| sendlatenotifications | TINYINT | 3 | 0 |
|
|
Allows separate enabling of notifications for late assignment submissions. |
||||||||||||||||||||||||||
| duedate | BIGINT | 19 | 0 |
|
|
The due date for the assignment. Displayed to students. |
||||||||||||||||||||||||||
| allowsubmissionsfromdate | BIGINT | 19 | 0 |
|
|
If set, submissions will only be accepted after this date. |
||||||||||||||||||||||||||
| grade | BIGINT | 19 | 0 |
|
|
The maximum grade for this assignment. Can be negative to indicate the use of a scale. |
||||||||||||||||||||||||||
| timemodified | BIGINT | 19 | 0 |
|
|
The time the settings for this assign module instance were last modified. |
||||||||||||||||||||||||||
| requiresubmissionstatement | TINYINT | 3 | 0 |
|
|
Forces the student to accept a submission statement when submitting an assignment |
||||||||||||||||||||||||||
| completionsubmit | TINYINT | 3 | 0 |
|
|
If this field is set to 1, then the activity will be automatically marked as 'complete' once the user submits their assignment. |
||||||||||||||||||||||||||
| cutoffdate | BIGINT | 19 | 0 |
|
|
The final date after which submissions will no longer be accepted for this assignment without an extensions. |
||||||||||||||||||||||||||
| gradingduedate | BIGINT | 19 | 0 |
|
|
The expected date for marking the submissions. |
||||||||||||||||||||||||||
| teamsubmission | TINYINT | 3 | 0 |
|
|
Do students submit in teams? |
||||||||||||||||||||||||||
| requireallteammemberssubmit | TINYINT | 3 | 0 |
|
|
If enabled, a submission will not be accepted until all team members have submitted it. |
||||||||||||||||||||||||||
| teamsubmissiongroupingid | BIGINT | 19 | 0 |
|
|
A grouping id to get groups for team submissions |
||||||||||||||||||||||||||
| blindmarking | TINYINT | 3 | 0 |
|
|
Hide student/grader identities until the reveal identities action is performed |
||||||||||||||||||||||||||
| hidegrader | TINYINT | 3 | 0 |
|
|
Hide the grader's identity from students. The opposite of blind marking. |
||||||||||||||||||||||||||
| revealidentities | TINYINT | 3 | 0 |
|
|
Show identities for a blind marking assignment |
||||||||||||||||||||||||||
| attemptreopenmethod | VARCHAR | 10 | untilpass |
|
|
How to determine when students are allowed to open a new submission. Valid options are manual and untilpass. |
||||||||||||||||||||||||||
| maxattempts | MEDIUMINT | 7 | 1 |
|
|
What is the maximum number of student attempts allowed for this assignment? -1 means unlimited. |
||||||||||||||||||||||||||
| markingworkflow | TINYINT | 3 | 0 |
|
|
If enabled, marking workflow features will be used in this assignment. |
||||||||||||||||||||||||||
| markingallocation | TINYINT | 3 | 0 |
|
|
If enabled, marking allocation features will be used in this assignment |
||||||||||||||||||||||||||
| markercount | TINYINT | 3 | 1 |
|
|
Number of markers for this assignment, for example, 2 for double marking |
||||||||||||||||||||||||||
| multimarkmethod | VARCHAR | 10 | √ | null |
|
|
How to calculate grade when markercount greater than 1 |
|||||||||||||||||||||||||
| multimarkrounding | TINYINT | 3 | √ | null |
|
|
How to round the grade calculation if using an average of marks |
|||||||||||||||||||||||||
| markinganonymous | TINYINT | 3 | 0 |
|
|
If enabled, marking anonymous features will be used in this assignment |
||||||||||||||||||||||||||
| sendstudentnotifications | TINYINT | 3 | 1 |
|
|
Default for send student notifications checkbox when grading. |
||||||||||||||||||||||||||
| preventsubmissionnotingroup | TINYINT | 3 | 0 |
|
|
If enabled a user will be unable to make a submission unless they are a member of a group. |
||||||||||||||||||||||||||
| activity | LONGTEXT | 2147483647 | √ | null |
|
|
Actions required to complete assignment, shown on submission page |
|||||||||||||||||||||||||
| activityformat | SMALLINT | 5 | 0 |
|
|
|||||||||||||||||||||||||||
| timelimit | BIGINT | 19 | 0 |
|
|
|||||||||||||||||||||||||||
| submissionattachments | TINYINT | 3 | 0 |
|
|
|||||||||||||||||||||||||||
| gradepenalty | TINYINT | 3 | 0 |
|
|
If enabled, penalties will be applied. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| assi_cou_ix | Performance | Asc | course |
| assi_gra_ix | Performance | Asc | gradepenalty |
| assi_tea_ix | Performance | Asc | teamsubmissiongroupingid |