read_sessions


Description

{“what”:“A reading session for a URL, with status, progress, and token counts.”,“why”:“Without it, there is no record of which URLs have been read, their status, or token consumption.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:32.339510317+00:00”}

Columns

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

{“what”:“Unique session identifier, a UUID string.”,“why”:“Without it, sessions cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:32.358560345+00:00”}

url text 2147483647 null

{“what”:“Original URL requested for reading.”,“why”:“Without it, the requested page cannot be identified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:32.382203862+00:00”}

final_url text 2147483647 null

{“what”:“URL after redirects, the actual page read.”,“why”:“Without it, the effective content source is unknown, especially after redirects.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:32.403504486+00:00”}

title text 2147483647 √ null

{“what”:“Page title extracted from the HTML.”,“why”:“Without it, the session lacks a human-readable label for display.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:32.473465880+00:00”}

status text 2147483647 null

{“what”:“Current state of the session, e.g., ‘active’ or ‘completed’.”,“why”:“Without it, it is unknown whether the session is still valid or needs retry.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:32.502810476+00:00”}

view text 2147483647 null

{“what”:“Rendering mode for the session, e.g., ‘article’ or ‘reader’.”,“why”:“Without it, the presentation format is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:32.533543318+00:00”}

index_map jsonb 2147483647 null

{“what”:“JSON mapping of content block indices to their positions.”,“why”:“Without it, the order and structure of content blocks cannot be reconstructed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:32.556875966+00:00”}

block_count int4 10 null

{“what”:“Number of content blocks in the session.”,“why”:“Without it, the total content size is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:32.642178954+00:00”}

next_offset int4 10 0

{“what”:“Byte or character offset for the next chunk to process.”,“why”:“Without it, resuming a paused session is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:32.772490578+00:00”}

rendered_tokens int4 10 null

{“what”:“Number of tokens in the rendered output.”,“why”:“Without it, token usage for the rendered view is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:32.913385228+00:00”}

raw_tokens int4 10 null

{“what”:“Number of tokens in the raw content.”,“why”:“Without it, token usage for the original content is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:32.997866971+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when the session was created.”,“why”:“Without it, session age and ordering are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:33.025077163+00:00”}

expires_at timestamptz 35,6 (now() + '01:00:00'::interval)

{“what”:“Timestamp when the session expires, one hour after creation by default.”,“why”:“Without it, stale sessions cannot be cleaned up.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:33.049949244+00:00”}

Indexes

Constraint Name Type Sort Column(s)
read_sessions_pkey Primary key Asc id
read_sessions_expires Performance Asc expires_at

Relationships