Local Activityvisibility Que Table Schema (local_activityvisibility_que)


Description

The update queue

local_activityvisibility_que table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
userid BIGINT 19 null
user.id Implied Constraint R
courseid BIGINT 19 null
course.id Implied Constraint R
updateat BIGINT 19 null

The timestamp after which the update should take place

Table contained -1 rows

local_activityvisibility_que table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
locaactique_upd_ix Performance Asc updateat
locaactique_usecouupd_ix Performance Asc/Asc/Asc userid + courseid + updateat

local_activityvisibility_que table relationships

Close relationships within degrees of separation