sealed_blocks


Description

{“what”:“Immutable content blocks grouped by session; each row is one sealed block.”,“why”:“Preserves a tamper-evident record of session content for later replay or verification.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:39.152025471+00:00”}

Columns

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

{“what”:“Text identifier of the session that owns this block.”,“why”:“Groups blocks per session; without it, blocks from different sessions are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:39.304640009+00:00”}

block_index int4 10 null

{“what”:“Integer position of the block within its session, starting at 0.”,“why”:“Defines order and uniqueness per session; without it, blocks cannot be sequenced or referenced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:39.591531957+00:00”}

content text 2147483647 null

{“what”:“Full text payload of the block, as originally sealed.”,“why”:“Holds the actual data; without it, the block is empty and useless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:39.605436190+00:00”}

token_estimate int4 10 null

{“what”:“Estimated token count of the content, used for cost or limit checks.”,“why”:“Enables budgeting and rate limiting; without it, usage cannot be predicted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:39.765592010+00:00”}

created_at timestamptz 35,6 now()

{“what”:“UTC timestamp when the block was inserted, set by default.”,“why”:“Provides creation time for auditing and ordering; without it, block age is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:39.799371210+00:00”}

Indexes

Constraint Name Type Sort Column(s)
sealed_blocks_pkey Primary key Asc/Asc session_key + block_index

Relationships