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