Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| field_id | int4 | 10 | null |
|
|
{“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 |