0 rows


Basic LTI pre-configured activities


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
lti.typeid lti_erd_lti_types_idR
lti_access_tokens.typeid ltiaccetoke_typ2_fkR
lti_tool_settings.typeid ltitoolsett_typ2_fkR
lti_types_categories.typeid ltitypecate_typ2_fkR
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.


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