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 |
|
|
{“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 |
|
|
{“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 |