Oauth2 User Field Mapping Table Schema (oauth2_user_field_mapping)


Mapping of oauth user fields to moodle fields.

oauth2_user_field_mapping table columns

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

The time this record was modified

timecreated BIGINT 19 null

The time this record was created.

usermodified BIGINT 19 null

The user who modified this record.

issuerid BIGINT 19 null
oauth2_issuer.id oautuserfielmapp_iss2_fk R

The oauth issuer.

externalfield VARCHAR 64

The fieldname returned by the userinfo endpoint.

internalfield VARCHAR 64

The name of the Moodle field this user field maps to.

Table contained -1 rows

oauth2_user_field_mapping table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
oautuserfielmapp_iss_ix Performance Asc issuerid
oautuserfielmapp_issint_uix Must be unique Asc/Asc issuerid + internalfield

oauth2_user_field_mapping table relationships