Lti Submission History Table Schema (lti_submission_history)


Description

Tracking of user submission history for the LTI activity

lti_submission_history table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
ltiid BIGINT 19 null
lti.id ltisubmhist_lti2_fk R
userid BIGINT 19 null
user.id ltisubmhist_use2_fk R
launchid BIGINT 19 null
timecreated BIGINT 19 null

Table contained -1 rows

lti_submission_history table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ltisubmhist_lti_ix Performance Asc ltiid
ltisubmhist_ltiuse_ix Performance Asc/Asc ltiid + userid
ltisubmhist_use_ix Performance Asc userid

lti_submission_history table relationships

Close relationships within degrees of separation