assign_user_flags

0 rows


Description

List of flags that can be set for a single user in a single assignment.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 0
user.id assiuserflag_use2_fkR

The id of the user these flags apply to.

assignment BIGINT 19 0
assign.id assiuserflag_ass2_fkR

The assignment these flags apply to.

locked BIGINT 19 0

Student cannot make any changes to their submission if this flag is set.

mailed SMALLINT 5 0

Has the student been sent a notification about this grade update?

extensionduedate BIGINT 19 0

An extension date assigned to an individual student.

workflowstate VARCHAR 20 null

The current workflow state of the grade

allocatedmarker BIGINT 19 0

The allocated marker to this submission

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
assiuserflag_ass_ix Performance Asc assignment
assiuserflag_mai_ix Performance Asc mailed
assiuserflag_use_ix Performance Asc userid

Relationships