lti_types

0 rows


Description

Basic LTI pre-configured activities

Columns

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
name VARCHAR 255 basiclti Activity
baseurl LONGTEXT 2147483647 null
tooldomain VARCHAR 255
state TINYINT 3 2
course BIGINT 19 null
coursevisible BIT 1 0
ltiversion VARCHAR 10
clientid VARCHAR 255 null
toolproxyid BIGINT 19 null
enabledcapability LONGTEXT 2147483647 null
parameter LONGTEXT 2147483647 null
icon LONGTEXT 2147483647 null
secureicon LONGTEXT 2147483647 null
createdby BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
description LONGTEXT 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ltitype_cli2_uix Must be unique Asc clientid
ltitype_cou2_ix Performance Asc course
ltitype_too2_ix Performance Asc tooldomain

Relationships