prism_values


Description

{“what”:“Values belonging to a prism, each with a name and description.”,“why”:“Without it, prisms have no list of selectable values.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:26.926040127+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
slug text 2147483647 null
profile_org_views.prism_value_slug profile_org_views_prism_value_slug_fkey R

{“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
prisms.slug prism_values_prism_slug_fkey R

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

Relationships