metabase_field_user_settings


Description

Mirror table of metabase_field to keep track of user-set values (only settable fields are mirrored)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
field_id int4 10 null
metabase_field.id fk_field_user_setting_field_id C

{“what”:“Identifier of the field these settings customize.”,“why”:“Uniquely links each settings row to a field; without it, settings cannot be associated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.378700320+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when this settings row was created.”,“why”:“Provides audit trail and ordering; without it, creation time is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.390287418+00:00”}

updated_at timestamptz 35,6 now()

{“what”:“Timestamp of the last update to this settings row.”,“why”:“Tracks changes and supports concurrency checks; without it, staleness is undetectable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.400186426+00:00”}

semantic_type varchar 254 √ null

{“what”:“Semantic meaning of the field, e.g. category, latitude, URL.”,“why”:“Drives Metabase’s automatic display and analysis behavior; without it, field semantics are guessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.414006084+00:00”}

description text 2147483647 √ null

{“what”:“Free-form explanation of the field’s content or purpose.”,“why”:“Shown to users in the UI to clarify field meaning; without it, context is missing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.425390983+00:00”}

display_name varchar 254 √ null

{“what”:“Custom label shown for the field instead of the raw column name.”,“why”:“Allows user-friendly names without renaming the database column; without it, raw name is used.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.439949498+00:00”}

visibility_type varchar 32 √ null

{“what”:“Controls field visibility, e.g. normal, hidden, sensitive.”,“why”:“Determines whether and how the field appears in queries and results; without it, visibility is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.458212319+00:00”}

fk_target_field_id int4 10 √ null

{“what”:“ID of the field this foreign key references.”,“why”:“Defines the relationship target for FK fields; without it, FK relationships are incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.484459098+00:00”}

has_field_values text 2147483647 √ null

{“what”:“Indicates how field values are handled, e.g. list, search, none.”,“why”:“Configures the value picker in the query builder; without it, value selection is not optimized.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.499507174+00:00”}

effective_type varchar 255 √ null

{“what”:“Overridden data type for the field, e.g. type/Integer.”,“why”:“Corrects or refines the database type for Metabase’s type system; without it, type inference may be wrong.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.514912234+00:00”}

coercion_strategy varchar 255 √ null

{“what”:“Strategy to convert the field’s data to the effective type.”,“why”:“Defines how to parse or cast values; without it, type conversion is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.526545690+00:00”}

caveats text 2147483647 √ null

{“what”:“Warnings or limitations about the field’s data quality.”,“why”:“Alerts users to potential issues; without it, data pitfalls are hidden.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.541692023+00:00”}

points_of_interest text 2147483647 √ null

{“what”:“Notes about interesting aspects or usage of the field.”,“why”:“Provides context for analysts; without it, field insights are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.554381136+00:00”}

nfc_path varchar 254 √ null

{“what”:“Path to the field in the NFC (nested field container) hierarchy.”,“why”:“Identifies the field’s location in nested structures; without it, nested field navigation is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.568894914+00:00”}

json_unfolding bool 1 √ null

{“what”:“Flag indicating whether JSON fields should be unfolded into separate columns.”,“why”:“Controls JSON expansion in queries; without it, JSON handling is not customizable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.584023374+00:00”}

settings text 2147483647 √ null

{“what”:“JSON-encoded additional settings for the field.”,“why”:“Stores arbitrary field-specific configuration; without it, extensibility is limited.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.597746538+00:00”}

Indexes

Constraint Name Type Sort Column(s)
metabase_field_user_settings_pkey Primary key Asc field_id

Relationships