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