Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
||||||||||||||||||||||
course | BIGINT | 19 | 0 |
|
|
|||||||||||||||||||||||
name | VARCHAR | 255 |
|
|
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 | none |
|
|
How to determine when students are allowed to open a new submission. Valid options are none, manual, 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 |
||||||||||||||||||||||
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 |
|
|
||||||||||||||||||||||
activityformat | SMALLINT | 5 | 0 |
|
|
|||||||||||||||||||||||
timelimit | BIGINT | 19 | 0 |
|
|
|||||||||||||||||||||||
submissionattachments | TINYINT | 3 | 0 |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
assi_cou_ix | Performance | Asc | course |
assi_tea_ix | Performance | Asc | teamsubmissiongroupingid |