app_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 bigserial 19 √ nextval('app_auth_oauth2_linked_login_id_seq'::regclass)
timecreated int8 19 null
timemodified int8 19 null
usermodified int8 19 null
app_user.id Defined in XMLR
userid int8 19 null
app_user.id Defined in XMLR
issuerid int8 19 null
app_oauth2_issuer.id Defined in XMLR
username varchar 255 ''::character varying
email text 2147483647 null
confirmtoken varchar 64 ''::character varying
confirmtokenexpires int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
app_authoautlinklogi_id_pk Primary key Asc id
app_authoautlinklogi_iss_ix Performance Asc issuerid
app_authoautlinklogi_issuse_ix Performance Asc/Asc issuerid + username
app_authoautlinklogi_use2_ix Performance Asc userid
app_authoautlinklogi_use_ix Performance Asc usermodified
app_authoautlinklogi_useis_uix Must be unique Asc/Asc/Asc userid + issuerid + username

Relationships

Close relationships within degrees of separation