Auth Oauth2 Linked Login Table Schema (auth_oauth2_linked_login)


Description

Accounts linked to a users Moodle account.

auth_oauth2_linked_login table 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_fk R
userid BIGINT 19 null
user.id authoautlinklogi_use4_fk R

The user account this oauth login is linked to.

issuerid BIGINT 19 null
oauth2_issuer.id authoautlinklogi_iss2_fk R
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

Table contained -1 rows

auth_oauth2_linked_login table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
authoautlinklogi_iss_ix Performance Asc issuerid
authoautlinklogi_issuse_ix Performance Asc/Asc issuerid + username
authoautlinklogi_use2_ix Performance Asc userid
authoautlinklogi_use_ix Performance Asc usermodified
authoautlinklogi_useissuse_uix Must be unique Asc/Asc/Asc userid + issuerid + username

auth_oauth2_linked_login table relationships