app_auth_oauth2_linked_login

0 rows


Description

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

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 varchar 100 ''::character varying
confirmed int2 5 0
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_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])))

Relationships

Close relationships within degrees of separation