workspace_graph


Description

{“what”:“One row per workspace holding its current graph definition.”,“why”:“Persists graph data so it survives restarts and is accessible across sessions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:03.841485082+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“Unique numeric identifier for each graph row.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:03.855224561+00:00”}

workspace_id int4 10 null
workspace.id fk_workspace_graph_workspace_id C

{“what”:“Identifier of the workspace this graph belongs to.”,“why”:“Without it, graphs cannot be associated with a specific workspace, making multi-tenant isolation impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:03.870215743+00:00”}

graph text 2147483647 null

{“what”:“Serialized graph content (e.g., JSON) defining nodes and edges.”,“why”:“Without it, there is no graph data to display or edit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:03.892429566+00:00”}

graph_version int8 19 0

{“what”:“Integer counter incremented on each graph update; starts at 0.”,“why”:“Without it, concurrent edits could overwrite each other silently.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:03.917101539+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp with time zone of row insertion.”,“why”:“Without it, audit trails and ordering of graph creation are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:03.934275074+00:00”}

updated_at timestamptz 35,6 now()

{“what”:“Timestamp with time zone of last modification.”,“why”:“Without it, you cannot tell if a graph changed since a client last fetched it.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:03.945995870+00:00”}

Indexes

Constraint Name Type Sort Column(s)
workspace_graph_pkey Primary key Asc id
idx_workspace_graph_workspace_version Must be unique Asc/Asc workspace_id + graph_version

Relationships