Enrol Lti Lti2 Resource Link Table Schema (enrol_lti_lti2_resource_link)


Description

Link from the consumer to the tool

enrol_lti_lti2_resource_link table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
enrol_lti_lti2_resource_link.primaryresourcelinkid enroltilti2resolink_pri2_fk R
enrol_lti_lti2_user_result.resourcelinkid enroltilti2userresu_res2_fk R
contextid BIGINT 19 √ null
enrol_lti_lti2_context.id enroltilti2resolink_con3_fk R
consumerid BIGINT 19 √ null
enrol_lti_lti2_consumer.id enroltilti2resolink_con4_fk R
ltiresourcelinkkey VARCHAR 255
settings LONGTEXT 2147483647 √ null
primaryresourcelinkid BIGINT 19 √ null
enrol_lti_lti2_resource_link.id enroltilti2resolink_pri2_fk R
shareapproved BIT 1 √ null
created BIGINT 19 null
updated BIGINT 19 null

Table contained -1 rows

enrol_lti_lti2_resource_link table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
enroltilti2resolink_con2_ix Performance Asc consumerid
enroltilti2resolink_con_ix Performance Asc contextid
enroltilti2resolink_pri_ix Performance Asc primaryresourcelinkid

enrol_lti_lti2_resource_link table relationships

Close relationships within degrees of separation