Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each metric row.”,“why”:“Without it, metrics cannot be uniquely referenced for joins, updates, or deletes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:15.315225489+00:00”} |
||||
| table_id | int4 | 10 | null |
|
|
{“what”:“ID of the data table this metric is defined against.”,“why”:“Without it, the metric’s source table is unknown, so its definition cannot be executed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:15.525099382+00:00”} |
|||||
| creator_id | int4 | 10 | null |
|
|
{“what”:“ID of the user who created this metric.”,“why”:“Without it, ownership and audit trail for metric changes is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:15.545476096+00:00”} |
|||||
| name | varchar | 254 | null |
|
|
{“what”:“Short human-readable metric name, e.g., ‘Revenue’.”,“why”:“Without it, metrics cannot be displayed or referenced in UI and reports.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:15.992454093+00:00”} |
|||||
| description | text | 2147483647 | √ | null |
|
|
{“what”:“Free-text explanation of the metric’s meaning and use.”,“why”:“Without it, consumers cannot understand the metric’s intent, leading to misuse.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:16.599958857+00:00”} |
||||
| archived | bool | 1 | false |
|
|
{“what”:“Flag indicating whether the metric is hidden from active use; true means archived.”,“why”:“Without it, retired metrics would still appear in lists and be used, causing confusion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:16.838781128+00:00”} |
|||||
| definition | text | 2147483647 | null |
|
|
{“what”:“SQL expression or formula that computes the metric value.”,“why”:“Without it, the metric cannot be calculated or validated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:17.474573138+00:00”} |
|||||
| created_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp when the metric row was created, in UTC.”,“why”:“Without it, audit history and ordering of metric creation is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:17.485666468+00:00”} |
|||||
| updated_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp of the last modification to this metric row.”,“why”:“Without it, stale or conflicting edits cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:17.676500035+00:00”} |
|||||
| points_of_interest | text | 2147483647 | √ | null |
|
|
{“what”:“Free-text notes highlighting notable aspects or anomalies in the metric.”,“why”:“Without it, analysts miss context about unusual data patterns.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:17.794196467+00:00”} |
||||
| caveats | text | 2147483647 | √ | null |
|
|
{“what”:“Free-text warnings about limitations or conditions affecting metric interpretation.”,“why”:“Without it, users may misinterpret metric values under certain conditions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:18.239509304+00:00”} |
||||
| how_is_this_calculated | text | 2147483647 | √ | null |
|
|
{“what”:“Plain-language explanation of the calculation steps behind the metric.”,“why”:“Without it, non-technical users cannot trust or verify the metric’s methodology.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:18.294149805+00:00”} |
||||
| show_in_getting_started | bool | 1 | false |
|
|
{“what”:“Flag indicating whether the metric appears in the getting-started guide for new users.”,“why”:“Without it, onboarding content cannot be curated to highlight key metrics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:18.434907380+00:00”} |
|||||
| entity_id | bpchar | 21 | √ | null |
|
|
{“what”:“Single-character code identifying the entity type this metric applies to.”,“why”:“Without it, metrics cannot be filtered by entity type, making cross-entity comparisons ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:18.510655107+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| metric_pkey | Primary key | Asc | id |
| idx_metric_creator_id | Performance | Asc | creator_id |
| idx_metric_show_in_getting_started | Performance | Asc | show_in_getting_started |
| idx_metric_table_id | Performance | Asc | table_id |
| metric_entity_id_key | Must be unique | Asc | entity_id |