query_field

{“what”:“Integer primary key, unique per row.”,“why”:“Without it, rows cannot be uniquely identified for updates or deletions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:25.860345322+00:00”}

{“what”:“Identifier of the query card this field belongs to.”,“why”:“Without it, a field mapping cannot be associated with a specific card, making queries ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:25.896765042+00:00”}

{“what”:“Optional identifier of a predefined field definition this mapping refers to.”,“why”:“Without it, the mapping cannot link to field metadata like label or type when using a predefined field.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:26.010681964+00:00”}

{“what”:“Flag indicating whether the column reference is explicit (true) or derived from field_id (false).”,“why”:“Without it, the query builder cannot decide whether to use the column/table/schema directly or resolve via field_id.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:26.120523966+00:00”}

{“what”:“Name of the database column to select or filter on.”,“why”:“Without it, the query has no column to reference, so the SELECT or WHERE clause cannot be built.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:26.179418171+00:00”}

{“what”:“Optional table name that qualifies the column.”,“why”:“Without it, the column may be ambiguous if multiple tables are in scope.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:26.228270475+00:00”}

{“what”:“Optional numeric identifier of the table, alternative to the table name.”,“why”:“Without it, the table can only be referenced by name, which may change or be ambiguous across schemas.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:26.379581205+00:00”}

{“what”:“Database schema that qualifies the table, if any.”,“why”:“Without it, the table may be searched in the default schema, causing wrong resolution.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:26.508103766+00:00”}