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 |