enrol_lti_app_registration

0 rows


Description

Details of each application that has been registered with the tool

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
enrol_lti_deployment.platformid enroltidepl_pla2_fkR
name VARCHAR 255

Common name to identify this platform to users

platformid LONGTEXT 2147483647 null

The issuer URL

clientid VARCHAR 1333 null

The clientid string, generated by the platform when setting up the tool.

uniqueid VARCHAR 255

A unique local id, which can be used in the initiate login URI to provide {iss, clientid} uniqueness in the absence of the optional client_id claim.

platformclienthash VARCHAR 64 null

SHA256 hash of the platformid (issuer) and clientid

platformuniqueidhash VARCHAR 64 null

SHA256 hash of the platformid (issuer) and uniqueid

authenticationrequesturl LONGTEXT 2147483647 null

The authorisation endpoint of the platform

jwksurl LONGTEXT 2147483647 null

The JSON Web Key Set URL for the platform

accesstokenurl LONGTEXT 2147483647 null
status BIT 1 0

Status of the registration, used to denote draft (incomplete) or active (complete)

timecreated BIGINT 19 null
timemodified BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
enroltiappregi_pla2_uix Must be unique Asc platformuniqueidhash
enroltiappregi_pla_uix Must be unique Asc platformclienthash
enroltiappregi_uni_uix Must be unique Asc uniqueid

Relationships