0 rows


Linking of external issuer account to a Totara user account - oauth2 may be either primary auth account or an alternative login method for other auth plugins


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 varchar 100 ''::character varying
confirmed int2 5 0
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_issu2_uix Must be unique Asc/Asc issuerid + userid
app_authoautlinklogi_issus_uix Must be unique Asc/Asc issuerid + username
app_authoautlinklogi_use2_ix Performance Asc userid
app_authoautlinklogi_use_ix Performance Asc usermodified

Check Constraints

Constraint Name Constraint
app_auth_oauth2_linked_loginconfirmed_enum ((confirmed = ANY (ARRAY[0, 1])))