dimension_values


Description

{“what”:“Lookup table of allowed values for each dimension.”,“why”:“Provides a controlled vocabulary for dimensions; without it values are free-form and inconsistent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.160367385+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
slug text 2147483647 null
contact_dimensions.tag_slug contact_dimensions_tag_slug_fkey R
dimension_edges.value_a dimension_edges_value_a_fkey R
dimension_edges.value_b dimension_edges_value_b_fkey R
profile_dimensions.tag_slug profile_dimensions_tag_slug_fkey R

{“what”:“Unique slug identifier for this dimension value, e.g. ‘small’.”,“why”:“Uniquely identifies a value for foreign keys and URLs; without it references are ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.177233266+00:00”}

dimension_slug text 2147483647 null
dimensions.slug dimension_values_dimension_slug_fkey R

{“what”:“Slug of the parent dimension this value belongs to.”,“why”:“Groups values under a dimension; without it a value cannot be scoped to its dimension.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.197490497+00:00”}

name text 2147483647 null

{“what”:“Display name for the value, e.g. ‘Small’.”,“why”:“Provides a user-friendly label for UI and reports; without it only the slug is shown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.210567718+00:00”}

description text 2147483647 null

{“what”:“Plain-language description of what this value means.”,“why”:“Clarifies the intended meaning to avoid misinterpretation by users or downstream logic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.226603874+00:00”}

sort_order int4 10 0

{“what”:“Integer used to order values within a dimension; lower appears first.”,“why”:“Determines display order; without it ordering is arbitrary or alphabetical.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.244448316+00:00”}

range_low float4 8,8 √ null

{“what”:“Lower bound (inclusive) of a numeric range for this value.”,“why”:“Defines a numeric interval for filtering or classification; without it range-based logic cannot be applied.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.275339939+00:00”}

range_high float4 8,8 √ null

{“what”:“Upper bound (inclusive) of a numeric range for this value.”,“why”:“Completes the range interval; without it the upper limit is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.293048354+00:00”}

headcount_min int4 10 √ null

{“what”:“Minimum headcount (number of employees) for this value.”,“why”:“Used to filter or categorize by company size; without it size-based segmentation is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.314475902+00:00”}

headcount_max int4 10 √ null

{“what”:“Maximum headcount (number of employees) for this value.”,“why”:“Defines the upper size limit; without it the size range is open-ended.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.333318946+00:00”}

examples text 2147483647 √ null

{“what”:“Comma-separated list of example instances for this value.”,“why”:“Helps users understand what fits this value; without it the value’s applicability is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.372919048+00:00”}

Indexes

Constraint Name Type Sort Column(s)
dimension_values_pkey Primary key Asc slug
idx_dv_dimension Performance Asc dimension_slug

Check Constraints

Constraint Name Constraint
dimension_values_range_high_check ((range_high >= (0)::double precision) AND (range_high <= (100)::double precision))
dimension_values_range_low_check ((range_low >= (0)::double precision) AND (range_low <= (100)::double precision))

Relationships