Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for this workspace input row.”,“why”:“Uniquely identifies each row for joins and updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.596994591+00:00”} |
||||
| workspace_id | int4 | 10 | null |
|
|
{“what”:“ID of the workspace that owns this input.”,“why”:“Scopes inputs to a workspace; without it, inputs from different workspaces mix.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.613755905+00:00”} |
|||||
| db_id | int4 | 10 | null |
|
|
{“what”:“ID of the database connection this input queries.”,“why”:“Determines which database to access; without it, the source database is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.624663958+00:00”} |
|||||
| schema | varchar | 254 | √ | null |
|
|
{“what”:“Database schema name (e.g., public) for the input table; null if not specified.”,“why”:“Disambiguates tables with the same name across schemas.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.634204565+00:00”} |
||||
| table | varchar | 254 | null |
|
|
{“what”:“Name of the table or view in the database that this input reads.”,“why”:“Specifies the data source; without it, no table to query.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.646342366+00:00”} |
|||||
| table_id | int4 | 10 | √ | null |
|
|
{“what”:“Optional identifier for the table in a metadata catalog; null if not linked.”,“why”:“Links to table metadata for validation; without it, only the name is available.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.657502190+00:00”} |
||||
| ref_id | bpchar | 36 | null |
|
|
{“what”:“Unique reference string (e.g., UUID) for this input, used externally.”,“why”:“Provides a stable identifier for API calls; without it, external systems cannot refer to this input.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.668802568+00:00”} |
|||||
| access_granted | bool | 1 | false |
|
|
{“what”:“Whether the workspace has been granted access to this input; defaults to false.”,“why”:“Controls visibility/usage; without it, access state is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.680864393+00:00”} |
|||||
| transform_version | int8 | 19 | 0 |
|
|
{“what”:“Version number of the transform applied to this input; starts at 0.”,“why”:“Tracks transform changes to invalidate caches; without it, stale data may be used.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.690036993+00:00”} |
|||||
| created_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp when this input was created, in UTC.”,“why”:“Audits creation time; without it, cannot track when the input was added.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.702315339+00:00”} |
|||||
| updated_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp of the last update to this input, in UTC.”,“why”:“Tracks modifications for concurrency; without it, stale updates are undetectable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:56.714962390+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| workspace_input_pkey | Primary key | Asc | id |
| idx_workspace_input_ref_id | Performance | Asc/Asc | workspace_id + ref_id |
| idx_workspace_input_table_id | Performance | Asc | table_id |
| idx_workspace_input_workspace_id | Performance | Asc | workspace_id |
| uq_workspace_input_versioned | Must be unique | Asc/Asc/Asc/Asc/Asc/Asc | workspace_id + ref_id + db_id + schema + table + transform_version |