Lti Submission Table Schema (lti_submission)


Description

Keeps track of individual submissions for LTI activities.

lti_submission table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
ltiid bigint 10 null
lti.id Implied Constraint R

ID of the LTI tool instance

userid bigint 10 null
user.id Implied Constraint R
datesubmitted bigint 10 null
dateupdated bigint 10 null
gradepercent decimal 10 null
originalgrade decimal 10 null
launchid bigint 10 null
state tinyint 2 null

Table contained -1 rows

lti_submission table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ltisubm_lti_ix Performance Asc ltiid

lti_submission table relationships