# 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
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.

### 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

### Relationships