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