lti_tool_settings

0 rows


Description

LTI tool setting values

Columns

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

Primary key of related tool proxy

typeid BIGINT 19 null
lti_types.id ltitoolsett_typ2_fkR
course BIGINT 19 null
course.id ltitoolsett_cou3_fkR

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

coursemoduleid BIGINT 19 null
lti.id ltitoolsett_cou4_fkR

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

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

Relationships