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