app_auth_oauth2_linked_login

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 10 of 11 entries

Indexes

Search:

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

Showing 1 to 6 of 6 entries

Check Constraints

Search:

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

Showing 1 to 1 of 1 entries

Relationships

Close relationships within degrees of separation

One
Two degrees

Description

Columns

Indexes

Check Constraints

Relationships

Close relationships within degrees of separation