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 |