oauth_tokens

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

CHAR

36

null

secret

VARCHAR

32

√

null

tstate

VARCHAR

1

√

null

consumer

CHAR

36

null

oauth_consumer.id

Defined in XMLR

token_ts

BIGINT

19

√

null

expire_ts

BIGINT

19

√

-1

verify

VARCHAR

32

√

null

download_token

VARCHAR

36

√

null

platform

VARCHAR

255

√

base

deleted

BIT

1

0

Showing 1 to 10 of 13 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc/Asc	id + deleted
constoken_key	Performance	Asc	consumer
idx_oauth_tstate_expire_ts	Performance	Asc/Asc	tstate + expire_ts
idx_platform_assigned_tstate	Performance	Asc/Asc/Asc	platform + assigned_user_id + tstate
oauth_state_ts	Performance	Asc/Asc	tstate + token_ts

Showing 1 to 5 of 5 entries

Relationships

Close relationships within degrees of separation

One
Two degrees