sessions


Description

{“what”:“A row per authenticated user session, with JWT and expiry.”,“why”:“Without it, there is no record of issued JWTs, so revocation and expiry checks are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:40.038533937+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
record_id text 2147483647 null

{“what”:“Unique opaque identifier for this session row.”,“why”:“Without it, there is no stable key to update or revoke a specific session.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:40.054785457+00:00”}

jti text 2147483647 null

{“what”:“JWT ID (jti claim) from the token, unique per issued token.”,“why”:“Without it, a token cannot be matched to its session for revocation or blacklisting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:40.070239896+00:00”}

user_id text 2147483647 null

{“what”:“Identifier of the user who owns this session.”,“why”:“Without it, sessions cannot be listed or revoked per user.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:40.082481981+00:00”}

issued_at timestamptz 35,6 null

{“what”:“Timestamp of session creation, with time zone.”,“why”:“Without it, session age and ordering cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:40.096624258+00:00”}

expires_at timestamptz 35,6 null

{“what”:“Timestamp when the session becomes invalid, with time zone.”,“why”:“Without it, expired sessions cannot be identified and rejected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:40.116949740+00:00”}

device_info text 2147483647 √ null

{“what”:“Free-form description of the client device or browser.”,“why”:“Without it, suspicious logins from new devices cannot be flagged.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:40.129275153+00:00”}

ip_address text 2147483647 √ null

{“what”:“IP address of the client at session start.”,“why”:“Without it, the origin of a session cannot be audited or compared.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:40.143957312+00:00”}

revoked_at timestamptz 35,6 √ null

{“what”:“Timestamp when the session was explicitly revoked, null if active.”,“why”:“Without it, revoked sessions cannot be distinguished from active ones.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:40.160697279+00:00”}

Indexes

Constraint Name Type Sort Column(s)
sessions_pkey Primary key Asc record_id
idx_ss_jti Performance Asc jti
idx_ss_user Performance Asc user_id
sessions_jti_key Must be unique Asc jti

Relationships