workspace_output_external


Description

Output tables produced by external transforms enclosed in a workspace

Columns

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

{“what”:“Unique integer identifier for this output record.”,“why”:“Needed to reference a specific output row in joins and updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:36.843063534+00:00”}

workspace_id int4 10 null
workspace.id fk_workspace_output_external_workspace_id C

{“what”:“ID of the workspace that owns this output.”,“why”:“Associates output to a workspace; without it, output is orphaned.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:36.939021173+00:00”}

transform_id int4 10 null
transform.id fk_workspace_output_external_transform_id C

{“what”:“ID of the transform that produced this output.”,“why”:“Links output to its source transform, enabling lineage and re-run detection.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:37.031377343+00:00”}

db_id int4 10 null

{“what”:“ID of the database connection used for this output.”,“why”:“Identifies which database the output is written to, required for connection management.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:37.175678526+00:00”}

global_schema varchar 254 √ null

{“what”:“Schema name in the global database namespace, if any.”,“why”:“Distinguishes global schema when multiple; null if not applicable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:37.371134651+00:00”}

global_table varchar 254 null

{“what”:“Table name in the global database namespace.”,“why”:“Identifies the target table for global output, essential for write operations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:37.422417420+00:00”}

global_table_id int4 10 √ null

{“what”:“Internal ID of the global table, if known.”,“why”:“Allows direct reference to table metadata without name lookup, improving performance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:37.444822233+00:00”}

isolated_schema varchar 254 √ null

{“what”:“Schema name in the isolated (per-workspace) namespace, if any.”,“why”:“Distinguishes isolated schema when multiple; null if not applicable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:37.483514777+00:00”}

isolated_table varchar 254 null

{“what”:“Table name in the isolated database namespace.”,“why”:“Identifies the target table for isolated output, essential for write operations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:37.595649424+00:00”}

isolated_table_id int4 10 √ null

{“what”:“Internal ID of the isolated table, if known.”,“why”:“Allows direct reference to table metadata without name lookup, improving performance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:37.737683673+00:00”}

graph_version int8 19 0

{“what”:“Version number of the graph definition at time of output.”,“why”:“Ensures output corresponds to a specific graph version; detects stale outputs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:37.830665034+00:00”}

created_at timestamptz 35,6 null

{“what”:“Timestamp when this output record was created.”,“why”:“Needed for auditing and ordering of outputs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:37.846176373+00:00”}

updated_at timestamptz 35,6 null

{“what”:“Timestamp when this output record was last updated.”,“why”:“Tracks changes to output metadata; used for conflict detection.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:37.999348332+00:00”}

Indexes

Constraint Name Type Sort Column(s)
workspace_output_external_pkey Primary key Asc id
idx_workspace_output_external_transform_id Performance Asc transform_id
idx_workspace_output_external_workspace_id Performance Asc workspace_id
uq_workspace_output_external_versioned Must be unique Asc/Asc/Asc workspace_id + transform_id + graph_version

Relationships