workspace_output


Description

{“what”:“Records where each workspace’s output is written and with which transform version.”,“why”:“Without it, outputs have no defined destination or versioning.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:53.636630918+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“Unique integer identifier for each output record.”,“why”:“Without it, rows cannot be individually referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:53.691360466+00:00”}

workspace_id int4 10 null
workspace.id fk_workspace_output_workspace_id C
workspace_transform.workspace_id fk_workspace_output_ref_id C

{“what”:“Numeric identifier of the workspace that owns this output.”,“why”:“Without it, outputs from different workspaces would be indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:53.801624781+00:00”}

ref_id bpchar 36 null
workspace_transform.ref_id fk_workspace_output_ref_id C

{“what”:“Character reference code for this output, e.g., a UUID.”,“why”:“Without it, no stable external link to this output exists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:53.868922857+00:00”}

db_id int4 10 null

{“what”:“Numeric identifier of the database connection this output targets.”,“why”:“Without it, the target database is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:53.887716760+00:00”}

global_schema varchar 254 √ null

{“what”:“Schema name for the global table; null if global output is absent.”,“why”:“Without it, the global table cannot be located if not in default schema.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:53.929335762+00:00”}

global_table varchar 254 null

{“what”:“Name of the table in the global database where output is written.”,“why”:“Without it, there is no destination for global output.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:53.965960767+00:00”}

global_table_id int4 10 √ null

{“what”:“Numeric identifier of the global table record in metadata; null if unassigned.”,“why”:“Without it, cannot join to global table metadata.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:53.978790594+00:00”}

isolated_schema varchar 254 √ null

{“what”:“Schema name for the isolated table; null if isolated output is absent.”,“why”:“Without it, the isolated table cannot be located if not in default schema.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:54.000580656+00:00”}

isolated_table varchar 254 √ null

{“what”:“Name of the table in the isolated database; null if no isolated output.”,“why”:“Without it, there is no destination for isolated output.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:54.018807721+00:00”}

isolated_table_id int4 10 √ null

{“what”:“Numeric identifier of the isolated table record; null if unassigned.”,“why”:“Without it, cannot join to isolated table metadata.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:54.055681751+00:00”}

transform_version int8 19 0

{“what”:“Version number of the transformation logic that produced this output; starts at 0.”,“why”:“Without it, cannot know if output is stale or needs regeneration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:54.103726196+00:00”}

created_at timestamptz 35,6 null

{“what”:“Timestamp when this output record was created.”,“why”:“Without it, the creation time is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:54.135860051+00:00”}

updated_at timestamptz 35,6 null

{“what”:“Timestamp when this output record was last modified.”,“why”:“Without it, the last update time is unknown, breaking cache invalidation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:54.154360389+00:00”}

Indexes

Constraint Name Type Sort Column(s)
workspace_output_pkey Primary key Asc id
idx_workspace_output_ref_id Performance Asc ref_id
idx_workspace_output_workspace_id Performance Asc workspace_id
uq_workspace_output_versioned Must be unique Asc/Asc/Asc workspace_id + ref_id + transform_version

Relationships