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 19 √ null
userid BIGINT 19 0
user.id assiuserflag_use2_fk R

The id of the user these flags apply to.
assignment BIGINT 19 0
assign.id assiuserflag_ass2_fk R

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

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

Close relationships within degrees of separation