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