Table oauth_token
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 int8 19
oauth_token_permissions.oauth_token_id fkfbfeff9637910ee2 R
code varchar 40  √  null
created timestamp 29,6
expiry timestamp 29,6  √  null
token varchar 255
user_id varchar 255
username varchar 1024
client_id int8 19
oauth_client.id fk1a879e51f5ba4eba R
institution_id int8 19
institution.id fk1a879e51bc711081 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc oauth_token_pkey
user_id + client_id Must be unique Asc/Asc oauth_token_user_id_client_id_key
client_id Performance Asc oauthtokenclient
code Performance Asc oauthtokencode
token Performance Asc oauthtokenindex
institution_id Performance Asc tokeninstindex

Close relationships  within of separation: