# assign

0 rows

### Description

This table saves information about an instance of mod_assign in a course. For sample reports see https://docs.moodle.org/401/en/ad-hoc_contributed_reports#Assignment_Activity

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
assign_allocated_marker.assignment | assiallomark_ass2_fkR
assign_grades.assignment | assigrad_ass2_fkR
assign_mark.assignment | assimark_ass2_fkR
assign_overrides.assignid | assiover_ass2_fkR
assign_plugin_config.assignment | assiplugconf_ass2_fkR
assign_submission.assignment | assisubm_ass2_fkR
assign_user_flags.assignment | assiuserflag_ass2_fkR
assign_user_mapping.assignment | assiusermapp_ass2_fkR
assignfeedback_comments.assignment | assicomm_ass2_fkR
assignfeedback_file.assignment | assifile_ass2_fkR
assignsubmission_file.assignment | assifile_ass5_fkR
assignsubmission_onlinetext.assignment | assionli_ass2_fkR
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

### Relationships