Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| action_id | int4 | 10 | null |
|
|
{“what”:“Unique integer assigned to each query action.”,“why”:“Enables unique reference to a query action from other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:46.241448013+00:00”} |
|||||
| database_id | int4 | 10 | null |
|
|
{“what”:“Integer referencing the database used by this query.”,“why”:“Determines which database the query executes against.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:46.260420725+00:00”} |
|||||
| dataset_query | text | 2147483647 | null |
|
|
{“what”:“Query definition in the application’s dataset format (e.g., JSON).”,“why”:“Provides the executable query definition for the action.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:46.290381976+00:00”} |
|||||
| legacy_query | text | 2147483647 | √ | null |
|
|
{“what”:“Query in an older format, present only when different from dataset_query.”,“why”:“Supports clients that only understand the legacy query format.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:46.310391208+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_query_action | Primary key | Asc | action_id |
| idx_query_action_database_id | Performance | Asc | database_id |