Local Activityvisibility Table Schema (local_activityvisibility)


Default comment for local_activityvisibility, please edit me

local_activityvisibility 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
coursemoduleid BIGINT 19 null
course.id Implied Constraint R
visible BIT 1 null
lastmodifieddate BIGINT 19 null
instance BIGINT 19 0

The instance ID as defined in the course_module table.

Table contained -1 rows

local_activityvisibility table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
locaacti_usecou2_uix Must be unique Asc/Asc userid + coursemoduleid
locaacti_usecou_ix Performance Asc/Asc userid + courseid

local_activityvisibility table relationships