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 3 0
gradesynccompletion BIT 3 0
membersync BIT 3 0
membersyncmode BIT 3 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