Enrol Lti Tools Table Schema (enrol_lti_tools)


List of tools provided to the remote system

enrol_lti_tools table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
enrol_lti_tool_consumer_map.toolid enroltitoolconsmap_too2_fk R
enrol_lti_users.toolid enroltiuser_too2_fk R
enrolid BIGINT 19 null
enrol.id enroltitool_enr2_fk R
contextid BIGINT 19 null
context.id enroltitool_con2_fk R
institution VARCHAR 40
lang VARCHAR 30 en
timezone VARCHAR 100 99
maxenrolled BIGINT 19 0
maildisplay TINYINT 3 2
city VARCHAR 120
country VARCHAR 2
gradesync BIT 1 0
gradesynccompletion BIT 1 0
membersync BIT 1 0
membersyncmode BIT 1 0
roleinstructor BIGINT 19 null
rolelearner BIGINT 19 null
secret LONGTEXT 2147483647 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null

Table contained -1 rows

enrol_lti_tools table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
enroltitool_con_ix Performance Asc contextid
enroltitool_enr_ix Performance Asc enrolid

enrol_lti_tools table relationships