access_tokens


Description

Access tokens (short lifetime) distributed to users, to access a specific session.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
token VARBINARY 2000 null

The access token.

session_id BIGINT 19 null
sessions.session_id fk_access_tokens_sessions_session_id C
expires_at DATETIME 19 null

The time the token expires and becomes invalid. It should be deleted after this time.

issued_at DATETIME 19 CURRENT_TIMESTAMP

The time the token was issued.

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
expires_at Performance Asc expires_at
fk_access_tokens_sessions_session_id Performance Asc session_id
token Performance Asc token

Relationships