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 10 null
enrol_lti_tool_consumer_map.toolid enroltitoolconsmap_too2_fk R
enrol_lti_users.toolid enroltiuser_too2_fk R
enrolid bigint 10 null
enrol.id enroltitool_enr2_fk R
contextid bigint 10 null
context.id enroltitool_con2_fk R
institution varchar 40
lang varchar 30 en
timezone varchar 100 99
maxenrolled bigint 10 0
maildisplay tinyint 2 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 10 null
rolelearner bigint 10 null
secret longtext 2147483647 null
timecreated bigint 10 null
timemodified bigint 10 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