auth_oauth2_linked_login

0 rows


Description

Accounts linked to a users Moodle account.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
user.id authoautlinklogi_use3_fkR
userid BIGINT 19 null
user.id authoautlinklogi_use4_fkR

The user account this oauth login is linked to.

issuerid BIGINT 19 null
oauth2_issuer.id authoautlinklogi_iss2_fkR
username VARCHAR 255

The external username to map to this moodle account

email LONGTEXT 2147483647 null

The external email to map to this moodle account

confirmtoken VARCHAR 64

If this is not empty - the user has not confirmed their email to create the link.

confirmtokenexpires BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
authoautlinklogi_iss4_ix Performance Asc issuerid
authoautlinklogi_issuse2_ix Performance Asc/Asc issuerid + username
authoautlinklogi_use6_ix Performance Asc usermodified
authoautlinklogi_use8_ix Performance Asc userid
authoautlinklogi_useissus2_uix Must be unique Asc/Asc/Asc userid + issuerid + username

Relationships