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
issuerid BIGINT 19 null
oauth2_issuer.id authoautlinklogi_iss2_fkR
username VARCHAR 255
email LONGTEXT 2147483647 null
confirmtoken VARCHAR 64
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

Close relationships within degrees of separation