Lti Types Table Schema (lti_types)


Description

Basic LTI pre-configured activities

lti_types table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
lti.typeid lti_typ_fk R
lti_access_tokens.typeid ltiaccetoke_typ2_fk R
lti_tool_settings.typeid ltitoolsett_typ2_fk R
name VARCHAR 255 basiclti Activity

Activity name
baseurl LONGTEXT 2147483647 null
tooldomain VARCHAR 255
state TINYINT 3 2

Active = 1, Pending = 2, Rejected = 3
course BIGINT 19 null
coursevisible BIT 1 0
ltiversion VARCHAR 10
clientid VARCHAR 255 √ null
toolproxyid BIGINT 19 √ null

Primary key of related tool proxy (null for LTI 1 tools)
enabledcapability LONGTEXT 2147483647 √ null

Enabled capabilities, one per line (null for LTI 1 tools)
parameter LONGTEXT 2147483647 √ null

Launch parameters, one per line (null for LTI 1 tools)
icon LONGTEXT 2147483647 √ null

URL to icon file
secureicon LONGTEXT 2147483647 √ null

Secure URL to icon file
createdby BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
description LONGTEXT 2147483647 √ null

A description of what this LTI module is.

Table contained -1 rows

lti_types table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ltitype_cli_uix Must be unique Asc clientid
ltitype_cou_ix Performance Asc course
ltitype_too_ix Performance Asc tooldomain

lti_types table relationships

Close relationships within degrees of separation