Lti Table Schema (lti)


Description

This table contains Basic LTI activities instances

lti table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
lti_submission.ltiid ltisubm_lti2_fk R
lti_tool_settings.coursemoduleid ltitoolsett_cou4_fk R
ltiservice_gradebookservices.ltilinkid ltisgrad_lti2_fk R
course BIGINT 19 0

Course basiclti activity belongs to
name VARCHAR 255

name field for moodle instances
intro LONGTEXT 2147483647 √ null

General introduction of the basiclti activity
introformat SMALLINT 5 √ 0

Format of the intro field (MOODLE, HTML, MARKDOWN...)
timecreated BIGINT 19 0
timemodified BIGINT 19 0
typeid BIGINT 19 √ null
lti_types.id lti_typ_fk R

Basic LTI type
toolurl LONGTEXT 2147483647 null

Remote tool url
securetoolurl LONGTEXT 2147483647 √ null
instructorchoicesendname BIT 1 √ null

Send user's name
instructorchoicesendemailaddr BIT 1 √ null

Send user's email
instructorchoiceallowroster BIT 1 √ null

Allow the roster to be retrieved
instructorchoiceallowsetting BIT 1 √ null

Allow a tool to store a setting
instructorcustomparameters VARCHAR 255 √ null

Additional custom parameters provided by the instructor
instructorchoiceacceptgrades BIT 1 √ null

Accept grades from tool
grade BIGINT 19 100

Grade scale
launchcontainer TINYINT 3 1

Launch external tool in a pop-up
resourcekey VARCHAR 255 √ null
password VARCHAR 255 √ null
debuglaunch BIT 1 0

Enable the debug-style launch which pauses before auto-submit
showtitlelaunch BIT 1 0
showdescriptionlaunch BIT 1 0
servicesalt VARCHAR 40 √ null
icon LONGTEXT 2147483647 √ null
secureicon LONGTEXT 2147483647 √ null

Table contained -1 rows

lti table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
lti_cou_ix Performance Asc course
lti_typ_fk Performance Asc typeid

lti table relationships

Close relationships within degrees of separation