dimensions


Description

{“what”:“A dimension in a multidimensional data model; each row defines one analysis axis.”,“why”:“Without it, there is no catalog of available dimensions for slicing or grouping data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:08.152176906+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
slug text 2147483647 null
contact_dimensions.dimension_slug contact_dimensions_dimension_slug_fkey R
dimension_values.dimension_slug dimension_values_dimension_slug_fkey R
profile_dimensions.dimension_slug profile_dimensions_dimension_slug_fkey R

{“what”:“Unique URL-safe identifier for the dimension; used as foreign key.”,“why”:“Without it, dimensions cannot be referenced reliably by other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:08.168808965+00:00”}

name text 2147483647 null

{“what”:“Human-readable display name for the dimension.”,“why”:“Without it, users cannot identify the dimension in UI or reports.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:08.194562918+00:00”}

description text 2147483647 null

{“what”:“Free-text explanation of the dimension’s meaning and scope.”,“why”:“Without it, analysts cannot understand what the dimension represents.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:08.222693244+00:00”}

layer_order int4 10 null

{“what”:“Integer ordering for stacking dimension layers; lower values appear first.”,“why”:“Without it, the visual layering order of dimensions is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:08.239373553+00:00”}

applies_to text 2147483647 null

{“what”:“Target entity or fact table this dimension can be applied to.”,“why”:“Without it, it is unclear which datasets this dimension is valid for.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:08.257779296+00:00”}

axis_name text 2147483647 √ null

{“what”:“Optional label for the axis when this dimension is plotted.”,“why”:“Without it, charts lack a default axis title for this dimension.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:08.277184152+00:00”}

axis_low_label text 2147483647 √ null

{“what”:“Label for the low end of the axis range.”,“why”:“Without it, the lower bound of the axis is unlabeled, confusing readers.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:08.288617247+00:00”}

axis_high_label text 2147483647 √ null

{“what”:“Label for the high end of the axis range.”,“why”:“Without it, the upper bound of the axis is unlabeled, confusing readers.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:08.303404572+00:00”}

Indexes

Constraint Name Type Sort Column(s)
dimensions_pkey Primary key Asc slug

Check Constraints

Constraint Name Constraint
dimensions_applies_to_check (applies_to = ANY (ARRAY['company'::text, 'contact'::text, 'both'::text]))

Relationships