sessions


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

Table contained 0 rows

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