sessions

0 rows


Description

Sessions represent a logged in user, on a specific device.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
session_id BIGINT 19 null
access_tokens.session_id fk_access_tokens_sessions_session_id C
user_id BIGINT 19 null
users.group_id fk_sessions_users_user_id_group_id C
refresh_token VARBINARY 2000 null

Refresh tokens (unlimited lifetime) used by the backend to request fresh access tokens from the auth module

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc session_id
fk_sessions_users_user_id_group_id Performance Asc user_id
refresh_token Performance Asc refresh_token

Relationships