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