query_table


Description

{“what”:“Mapping of cards to database tables for query execution.”,“why”:“Without it, cards would have no defined data source.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:25.166505148+00:00”}

Columns

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

{“what”:“Unique integer assigned to each mapping row.”,“why”:“Provides a stable key for updates and joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:25.191034878+00:00”}

card_id int4 10 null
report_card.id fk_query_table_card_id C

{“what”:“Numeric ID of the card that owns this mapping.”,“why”:“Links a card to its data source; without it, card-to-table association is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:25.207629770+00:00”}

table_id int4 10 √ null
metabase_table.id fk_query_table_table_id C

{“what”:“Optional numeric ID of a registered table metadata record.”,“why”:“When present, enables joins to table metadata; null when only a raw name is used.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:25.240400740+00:00”}

schema varchar 254 √ null

{“what”:“Database schema qualifier such as ‘public’.”,“why”:“Disambiguates tables with same name in different schemas; null implies default schema.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:25.255698370+00:00”}

table varchar 254 null

{“what”:“Database table name such as ‘orders’.”,“why”:“Identifies the actual table to query; without it, the data source is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:25.316969882+00:00”}

Indexes

Constraint Name Type Sort Column(s)
query_table_pkey Primary key Asc id
idx_query_table_card_id Performance Asc card_id
idx_query_table_table_id Performance Asc table_id

Relationships