Enrol Lti Lti2 Consumer Table Schema (enrol_lti_lti2_consumer)


Description

LTI consumers interacting with moodle

enrol_lti_lti2_consumer table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
enrol_lti_lti2_context.consumerid enroltilti2cont_con2_fk R
enrol_lti_lti2_nonce.consumerid enroltilti2nonc_con2_fk R
enrol_lti_lti2_resource_link.consumerid enroltilti2resolink_con4_fk R
enrol_lti_lti2_tool_proxy.consumerid enroltilti2toolprox_con2_fk R
enrol_lti_tool_consumer_map.consumerid enroltitoolconsmap_con2_fk R
name VARCHAR 50
consumerkey256 VARCHAR 255
consumerkey LONGTEXT 2147483647 √ null
secret VARCHAR 1024
ltiversion VARCHAR 10 √ null
consumername VARCHAR 255 √ null
consumerversion VARCHAR 255 √ null
consumerguid VARCHAR 1024 √ null
profile LONGTEXT 2147483647 √ null
toolproxy LONGTEXT 2147483647 √ null
settings LONGTEXT 2147483647 √ null
protected BIT 1 null
enabled BIT 1 null
enablefrom BIGINT 19 √ null
enableuntil BIGINT 19 √ null
lastaccess BIGINT 19 √ null
created BIGINT 19 null
updated BIGINT 19 null

Table contained -1 rows

enrol_lti_lti2_consumer table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
enroltilti2cons_con_uix Must be unique Asc consumerkey256

enrol_lti_lti2_consumer table relationships

Close relationships within degrees of separation