Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| slug | text | 2147483647 | null |
|
|
{“what”:“Unique URL-safe identifier for a prism; primary key.”,“why”:“Without it, prisms cannot be referenced unambiguously in URLs or foreign keys.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:05.986413075+00:00”} |
|||||
| name | text | 2147483647 | null |
|
|
{“what”:“Human-readable display name for the prism.”,“why”:“Without it, users cannot distinguish prisms in UI lists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:06.112318511+00:00”} |
|||||
| description | text | 2147483647 | null |
|
|
{“what”:“Free-form explanation of the prism’s purpose or behavior.”,“why”:“Without it, the prism’s intent is undocumented.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:06.134057686+00:00”} |
|||||
| sort_order | int4 | 10 | 0 |
|
|
{“what”:“Integer for ordering prisms; lower appears first.”,“why”:“Without it, display order of prisms is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:06.149873984+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| prisms_pkey | Primary key | Asc | slug |