Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| value_a | text | 2147483647 | null |
|
|
{“what”:“A dimension value that anchors one endpoint of the edge.”,“why”:“Without it, the edge cannot be associated with a specific dimension value.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:46.985179153+00:00”} |
|||||
| value_b | text | 2147483647 | null |
|
|
{“what”:“A dimension value that anchors the other endpoint of the edge.”,“why”:“Without it, the edge’s second endpoint is missing, making the relationship incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.016718099+00:00”} |
|||||
| strength | text | 2147483647 | null |
|
|
{“what”:“A textual label or weight describing the edge’s nature.”,“why”:“Without it, the edge’s type or intensity is unknown, affecting analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.059406536+00:00”} |
|||||
| notes | text | 2147483647 | √ | null |
|
|
{“what”:“Optional free-form text for additional context about the edge.”,“why”:“Without it, rationale or caveats for the edge are lost, hindering maintenance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.101050949+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| dimension_edges_pkey | Primary key | Asc/Asc | value_a + value_b |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| dimension_edges_strength_check | (strength = ANY (ARRAY['always'::text, 'usually'::text, 'sometimes'::text, 'rarely'::text, 'never'::text])) |