Lti Table Schema (lti)


This table contains Basic LTI activities instances

lti table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
lti_submission.ltiid Implied Constraint R
lti_tool_settings.coursemoduleid ltitoolsett_cou4_fk R
course bigint 10 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 4 0

Format of the intro field (MOODLE, HTML, MARKDOWN...)

timecreated bigint 10 0
timemodified bigint 10 0
typeid bigint 10 null

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 10 100

Grade scale

launchcontainer tinyint 2 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 table relationships