Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for this external input record.”,“why”:“Enables stable reference and joins from other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:18.048802745+00:00”} |
||||
| workspace_id | int4 | 10 | null |
|
|
{“what”:“ID of the workspace this input belongs to.”,“why”:“Links the input to its workspace; without it, ownership is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:18.185277059+00:00”} |
|||||
| db_id | int4 | 10 | null |
|
|
{“what”:“ID of the external database connection.”,“why”:“Identifies which external database to query; ambiguous without it.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:18.216651015+00:00”} |
|||||
| schema | varchar | 254 | √ | null |
|
|
{“what”:“Schema name in the external database, if any.”,“why”:“Disambiguates tables with same name across schemas.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:18.240534872+00:00”} |
||||
| table | varchar | 254 | null |
|
|
{“what”:“Table name in the external database.”,“why”:“Specifies which table holds the input row; required for lookup.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:18.675640902+00:00”} |
|||||
| table_id | int4 | 10 | √ | null |
|
|
{“what”:“Primary key value of the row in the external table.”,“why”:“Identifies the specific row; null means whole table is input.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:18.687680383+00:00”} |
||||
| access_granted | bool | 1 | false |
|
|
{“what”:“Whether the workspace has permission to read this external data.”,“why”:“Prevents querying unauthorized data; without it, access control is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:18.708415379+00:00”} |
|||||
| graph_version | int8 | 19 | 0 |
|
|
{“what”:“Version number of the graph that last used this input.”,“why”:“Tracks staleness; helps decide when to refresh the graph.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:18.750553457+00:00”} |
|||||
| created_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp when this input record was created.”,“why”:“Audit trail; needed for debugging and lifecycle analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:18.786279610+00:00”} |
|||||
| updated_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp of last update to this record.”,“why”:“Shows when access or version changed; important for concurrency.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:18.893800356+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| workspace_input_external_pkey | Primary key | Asc | id |
| idx_workspace_input_external_workspace_id | Performance | Asc | workspace_id |
| uq_workspace_input_external_versioned | Must be unique | Asc/Asc/Asc/Asc/Asc | workspace_id + db_id + schema + table + graph_version |