0 rows


Accounts linked to a users Moodle account.


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 null authltilinklogi_use2_fkR

The user account the LTI user is linked to.

issuer LONGTEXT 2147483647 null
issuer256 VARCHAR 64

SHA256 hash of the issuer from which the platform user originates.

sub VARCHAR 255
sub256 VARCHAR 64

SHA256 hash of the subject identifying the user for the issuer.

timecreated BIGINT 19 null
timemodified BIGINT 19 null


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
authltilinklogi_use2_ix Performance Asc userid
authltilinklogi_useisssub2_uix Must be unique Asc/Asc/Asc userid + issuer256 + sub256