Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique numeric identifier for each log entry.”,“why”:“Without it, rows cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:54.611020159+00:00”} |
||||
| workspace_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the workspace the task belongs to.”,“why”:“Without it, cannot associate log entries with a specific workspace.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:54.622844064+00:00”} |
|||||
| task | varchar | 255 | null |
|
|
{“what”:“Name or type of task performed, e.g., ‘backup’.”,“why”:“Without it, the purpose of the log entry is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:54.637351818+00:00”} |
|||||
| created_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp when the log entry was first inserted.”,“why”:“Without it, cannot order entries by creation time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:54.656713909+00:00”} |
|||||
| updated_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp of the last modification to this log entry.”,“why”:“Without it, cannot detect if entry details changed after creation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:54.674540903+00:00”} |
|||||
| started_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp when the task execution started.”,“why”:“Without it, task duration cannot be computed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:54.688768261+00:00”} |
|||||
| completed_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp when the task finished; null if still running.”,“why”:“Without it, cannot know if task completed or its duration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:54.706049057+00:00”} |
||||
| status | varchar | 20 | √ | null |
|
|
{“what”:“Current state of the task, e.g., ‘running’, ‘success’, ‘failed’.”,“why”:“Without it, cannot filter or report on task outcomes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:54.722878536+00:00”} |
||||
| message | text | 2147483647 | √ | null |
|
|
{“what”:“Free-form details or error output from the task.”,“why”:“Without it, failure reasons or progress details are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:54.745507394+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| workspace_log_pkey | Primary key | Asc | id |
| idx_workspace_log_workspace_id | Performance | Asc | workspace_id |