enrol_lti_tools

0 rows


Description

List of tools provided to the remote system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
enrol_lti_tool_consumer_map.toolid enroltitoolconsmap_too2_fkR
enrol_lti_users.toolid enroltiuser_too2_fkR
enrolid BIGINT 19 null
enrol.id enroltitool_enr2_fkR
contextid BIGINT 19 null
context.id enroltitool_con2_fkR
ltiversion VARCHAR 15 LTI-1p3
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
uuid VARCHAR 36 √ null
provisioningmodelearner TINYINT 3 √ null
provisioningmodeinstructor TINYINT 3 √ null
timecreated BIGINT 19 null
timemodified BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
enroltitool_con_ix Performance Asc contextid
enroltitool_enr_ix Performance Asc enrolid
enroltitool_uui_uix Must be unique Asc uuid

Relationships

Close relationships within degrees of separation