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 |