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 19 null
ltiid BIGINT 19 null
lti.id ltisubm_lti2_fk R

ID of the LTI tool instance

userid BIGINT 19 null
user.id Implied Constraint R
datesubmitted BIGINT 19 null
dateupdated BIGINT 19 null
gradepercent DECIMAL 10,5 null
originalgrade DECIMAL 10,5 null
launchid BIGINT 19 null
state TINYINT 3 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