user_lastaccess

0 rows


Description

To keep track of course page access times, used in online participants block, and participants list

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 0
user.id user_lastaccess_erd_useridR
courseid BIGINT 19 0
course.id Implied ConstraintR
timeaccess BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
userlast_cou_ix Performance Asc courseid
userlast_use_ix Performance Asc userid
userlast_usecou_uix Must be unique Asc/Asc userid + courseid

Relationships