metric_important_field


Description

{“what”:“Links a metric to a field marked as important for that metric.”,“why”:“Without it, the set of important fields per metric is unknown, so metric context is incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:31.133698184+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“Surrogate primary key for each metric-field association row.”,“why”:“Provides a unique identifier for each link, enabling stable references and updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:31.151119015+00:00”}
metric_id int4 10 null
metric.id fk_metric_important_field_metric_id C

{“what”:“Foreign key to the metric that owns this important-field link.”,“why”:“Identifies which metric the field importance applies to; without it, the association is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:31.168699412+00:00”}
field_id int4 10 null
metabase_field.id fk_metric_important_field_metabase_field_id C

{“what”:“Foreign key to the field that is important for the linked metric.”,“why”:“Specifies which field is important; without it, the metric’s important fields cannot be enumerated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:31.184625251+00:00”}

Indexes

Constraint Name Type Sort Column(s)
metric_important_field_pkey Primary key Asc id
idx_metric_important_field_field_id Performance Asc field_id
idx_metric_important_field_metric_id Performance Asc metric_id
unique_metric_important_field_metric_id_field_id Must be unique Asc/Asc metric_id + field_id

Relationships

Close relationships within degrees of separation