Assign User Flags Table Schema (assign_user_flags)


Description

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

assign_user_flags table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
userid bigint 10 0
user.id assiuserflag_use2_fk R

The id of the user these flags apply to.

assignment bigint 10 0
assign.id assiuserflag_ass2_fk R

The assignment these flags apply to.

locked bigint 10 0

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

mailed smallint 4 0

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

extensionduedate bigint 10 0

An extension date assigned to an individual student.

workflowstate varchar 20 null

The current workflow state of the grade

allocatedmarker bigint 10 0

The allocated marker to this submission

Table contained -1 rows

assign_user_flags table 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

assign_user_flags table relationships