Enrol Lti Users table / enrol_lti_users - Moodle LMS 3.9 Database schema / Zoola Analytics

enrol_lti_users table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

userid

BIGINT

19

null

user.id

enroltiuser_use2_fk R

toolid

BIGINT

19

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,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

Showing 1 to 12 of 12 entries

Table contained -1 rows

enrol_lti_users table indexes

Search:

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

Showing 1 to 3 of 3 entries

Enrol Lti Users Table Schema (enrol_lti_users)

Description

enrol_lti_users table columns

enrol_lti_users table indexes

enrol_lti_users table relationships

Close relationships within degrees of separation