Table a413a5b9.oauth_tokens Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
id char 36
secret varchar 32  √  null
tstate varchar 1  √  null
consumer char 36
oauth_consumer
token_ts bigint 20  √  null
expire_ts bigint 20  √  -1
verify varchar 32  √  null
download_token varchar 36  √  null
platform varchar 255  √  base
deleted bit 1 0
callback_url varchar 255  √  null
contact_id char 36  √  null
contacts
assigned_user_id char 36  √  null
users

Analyzed at Sat Jan 13 08:16 UTC 2018

Indexes:
Column(s) Type Sort
id + deleted Primary key Asc/Asc
consumer Performance Asc
tstate + token_ts Performance Asc/Asc

Close relationships  within of separation: