Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| slug | text | 2147483647 | null |
|
|
{“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 |
|
|
{“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)) |