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 10 null
toolproxyid bigint 10 null
lti_tool_proxies.id ltitoolsett_too2_fk R

Primary key of related tool proxy

course bigint 10 null
course.id ltitoolsett_cou3_fk R

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

coursemoduleid bigint 10 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 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