lti

0 rows


Description

This table contains Basic LTI activities instances

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
lti_submission.ltiid lti_submission_erd_lti_idR
lti_tool_settings.coursemoduleid ltitoolsett_cou4_fkR
lti_types_config.typeid lti_types_config_erd_ltiidR
ltiservice_gradebookservices.ltilinkid ltisgrad_lti2_fkR
course BIGINT 19 0

Course basiclti activity belongs to

name VARCHAR 1333 ''

name field for moodle instances

intro LONGTEXT 2147483647 √ NULL

General introduction of the basiclti activity

introformat SMALLINT 5 √ 0

Format of the intro field (MOODLE, HTML, MARKDOWN…)

timecreated BIGINT 19 0
timemodified BIGINT 19 0
typeid BIGINT 19 √ NULL
lti_types.id lti_erd_lti_types_idR

Basic LTI type

toolurl LONGTEXT 2147483647 null

Remote tool url

securetoolurl LONGTEXT 2147483647 √ NULL
instructorchoicesendname BIT 3 √ NULL

Send user's name

instructorchoicesendemailaddr BIT 3 √ NULL

Send user's email

instructorchoiceallowroster BIT 3 √ NULL

Allow the roster to be retrieved

instructorchoiceallowsetting BIT 3 √ NULL

Allow a tool to store a setting

instructorcustomparameters LONGTEXT 2147483647 √ NULL

Additional custom parameters provided by the instructor

instructorchoiceacceptgrades BIT 3 √ NULL

Accept grades from tool

grade BIGINT 19 100

Grade scale

launchcontainer TINYINT 3 1

Launch external tool in a pop-up

resourcekey VARCHAR 255 √ NULL
password VARCHAR 255 √ NULL
debuglaunch BIT 3 0

Enable the debug-style launch which pauses before auto-submit

showtitlelaunch BIT 3 0
showdescriptionlaunch BIT 3 0
servicesalt VARCHAR 40 √ NULL
icon LONGTEXT 2147483647 √ NULL
secureicon LONGTEXT 2147483647 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
lti_cou_ix Performance Asc course
lti_erd_lti_types_id Performance Asc typeid

Relationships