0 rows


Accounts linked to a users Moodle account.


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 Defined in XMLR
userid int8 19 null Defined in XMLR
issuerid int8 19 null Defined in XMLR
username varchar 255 ''::character varying
email text 2147483647 null
confirmtoken varchar 64 ''::character varying
confirmtokenexpires int8 19 null


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