enrol_lti_users

0 rows


Description

User access log and gradeback data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 null
user.id enroltiuser_use2_fkR
toolid BIGINT 19 null
enrol_lti_tools.id enroltiuser_too2_fkR
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,5 null

The last grade that was sent

lastaccess BIGINT 19 null

The time the user last accessed

timecreated BIGINT 19 null

The time the user was created

Indexes

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

Relationships