Lti Tool Settings Table Schema (lti_tool_settings)


LTI tool setting values

lti_tool_settings table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
toolproxyid bigint 10 null ltitoolsett_too2_fk R

Primary key of related tool proxy

course bigint 10 null ltitoolsett_cou3_fk R

Primary key of course (null for system-wide settings)

coursemoduleid bigint 10 null ltitoolsett_cou4_fk R

Primary key of course module - tool link added to course (null for system-wide and context-wide settings)

settings longtext 2147483647 null

Setting values as JSON

timecreated bigint 10 null

Date/time at which the record was created

timemodified bigint 10 null

Date/time at which the record was last modified

Table contained -1 rows

lti_tool_settings table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ltitoolsett_cou2_ix Performance Asc coursemoduleid
ltitoolsett_cou_ix Performance Asc course
ltitoolsett_too_ix Performance Asc toolproxyid

lti_tool_settings table relationships