workspace_input_external


Description

{“what”:“External data source linked to a workspace; identifies a row in an external DB table.”,“why”:“Tracks which external rows are inputs to a workspace for graph processing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:17.754529137+00:00”}

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
workspace.id fk_workspace_input_external_workspace_id C

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

Relationships