SchemaSpy - Table a1fa2ef1.oauth_tokens

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

char

36

secret

varchar

32

√

null

tstate

varchar

1

√

null

consumer

char

36

oauth_consumer.id

Defined in XML R

token_ts

bigint

20

√

null

verify

varchar

32

√

null

deleted

bit

1

0

callback_url

varchar

255

√

null

assigned_user_id

char

36

√

null

users.id

Defined in XML R

Analyzed at Tue Jul 21 07:47 UTC 2015

Indexes:

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