Lti Tool Settings Table Schema (lti_tool_settings)


Description

LTI tool setting values

lti_tool_settings table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
toolproxyid BIGINT 19 null
lti_tool_proxies.id ltitoolsett_too2_fk R

Primary key of related tool proxy

typeid BIGINT 19 null
lti_types.id ltitoolsett_typ2_fk R
course BIGINT 19 null
course.id ltitoolsett_cou3_fk R

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

coursemoduleid BIGINT 19 null
lti.id 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 19 null

Date/time at which the record was created

timemodified BIGINT 19 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
ltitoolsett_typ_ix Performance Asc typeid

lti_tool_settings table relationships