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