room_completion


Description

{“what”:“Aggregated completion snapshot for a room: percentage, attained and attainable counts.”,“why”:“Centralizes per-room completion metrics so they can be queried without scanning raw events.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:52.919587858+00:00”}

Columns

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

{“what”:“Unique identifier of the room, as a text string.”,“why”:“Without it, rows for different rooms cannot be distinguished or referenced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:52.943506395+00:00”}

domain text 2147483647 √ null

{“what”:“Optional text label that groups rooms into a domain.”,“why”:“Without it, completion metrics cannot be segmented by domain, making domain-level analysis impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:52.963453062+00:00”}

completion_pct int4 10 0

{“what”:“Integer percentage from 0 to 100 indicating completion level.”,“why”:“Without it, the overall completion level is not directly available and must be derived from attained/attainable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:52.981412333+00:00”}

attained int4 10 0

{“what”:“Count of completed items or tasks in the room.”,“why”:“Without it, the actual completed count is missing, so progress cannot be measured.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:53.008742735+00:00”}

attainable int4 10 0

{“what”:“Total count of items or tasks that can be completed in the room.”,“why”:“Without it, the denominator for completion percentage is unknown, so relative progress cannot be computed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:53.030443662+00:00”}

computed_at timestamptz 35,6 now()

{“what”:“Timestamp (with time zone) when this completion snapshot was last calculated.”,“why”:“Without it, the freshness of the data is unknown, risking decisions based on stale metrics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:53.069577688+00:00”}

Indexes

Constraint Name Type Sort Column(s)
room_completion_pkey Primary key Asc room_id

Relationships