workspace_log


Description

{“what”:“Log entry for a task executed on a workspace; one row per task attempt.”,“why”:“Without it, no audit trail of workspace operations exists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:54.598160353+00:00”}

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
workspace.id fk_workspace_log_workspace_id C

{“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

Relationships