Enrol Lti Users Table Schema (enrol_lti_users)


Description

User access log and gradeback data

enrol_lti_users table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
userid bigint 10 null
user.id enroltiuser_use2_fk R
toolid bigint 10 null
enrol_lti_tools.id enroltiuser_too2_fk R
serviceurl longtext 2147483647 null
sourceid longtext 2147483647 null
consumerkey longtext 2147483647 null
consumersecret longtext 2147483647 null
membershipsurl longtext 2147483647 null
membershipsid longtext 2147483647 null
lastgrade decimal 10 null

The last grade that was sent

lastaccess bigint 10 null

The time the user last accessed

timecreated bigint 10 null

The time the user was created

Table contained -1 rows

enrol_lti_users table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
enroltiuser_too_ix Performance Asc toolid
enroltiuser_use_ix Performance Asc userid

enrol_lti_users table relationships