Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| slug | text | 2147483647 | null |
|
|
{“what”:“Unique text identifier for this value; primary key.”,“why”:“Without it, rows cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:26.943546317+00:00”} |
|||||
| prism_slug | text | 2147483647 | null |
|
|
{“what”:“Slug of the prism this value belongs to.”,“why”:“Without it, values cannot be associated with a specific prism.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:26.956363502+00:00”} |
|||||
| name | text | 2147483647 | null |
|
|
{“what”:“Display name for the value.”,“why”:“Without it, users cannot identify the value in UI.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:26.986050783+00:00”} |
|||||
| description | text | 2147483647 | null |
|
|
{“what”:“Detailed explanation of the value’s meaning.”,“why”:“Without it, the value’s purpose is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:27.007192805+00:00”} |
|||||
| sort_order | int4 | 10 | 0 |
|
|
{“what”:“Integer for ordering values within a prism; lower comes first.”,“why”:“Without it, the display order of values is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:27.022603562+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| prism_values_pkey | Primary key | Asc | slug |
| idx_pv_prism | Performance | Asc | prism_slug |