oauth_access_tokens


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
resource_owner_id uuid 2147483647 √ null
machine_users.id fk_rails_ee63f25419 R
application_id uuid 2147483647 null
oauth_applications.id fk_rails_732cb83ab7 R
token varchar 2147483647 null
refresh_token varchar 2147483647 √ null
expires_in int4 10 √ null
scopes varchar 2147483647 √ null
created_at timestamp 29,6 null
revoked_at timestamp 29,6 √ null
previous_refresh_token varchar 2147483647 ''::character varying

Indexes

Constraint Name Type Sort Column(s)
oauth_access_tokens_pkey Primary key Asc id
index_oauth_access_tokens_on_application_id Performance Asc application_id
index_oauth_access_tokens_on_refresh_token Must be unique Asc refresh_token
index_oauth_access_tokens_on_resource_owner_id Performance Asc resource_owner_id
index_oauth_access_tokens_on_token Must be unique Asc token

Relationships

Close relationships within degrees of separation