Table sem5.dbo.OAUTH_ACCESS_TOKEN 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
TOKEN_ID varchar 80
TOKEN varbinary 1000  √  null
AUTHENTICATION_ID varchar 80  √  null
AUTHENTICATION image 2147483647  √  null
REFRESH_TOKEN varchar 80  √  null
CLIENT_ID varchar 80  √  null
USER_ID varchar 80  √  null
CREATION_DATE datetime 16,3

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
TOKEN_ID Primary key Asc PK_OAUTH_ACCESS_TOKEN
REFRESH_TOKEN Performance Asc I_OAUTH_ACCESS_TOKEN_REFRESH_TOKEN
USER_ID Performance Asc I_OAUTH_ACCESS_TOKEN_USER_ID