Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
{“what”:“Unique UUID assigned at insert; primary key.”,“why”:“Needed to reference a specific showcase in URLs, logs, and foreign keys.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:54.669721841+00:00”} |
|||||
| dataset_version_id | uuid | 2147483647 | null |
|
|
{“what”:“UUID of the dataset version this showcase is built from.”,“why”:“Links the showcase to its source dataset version; without it, the showcase is orphaned.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:54.693522581+00:00”} |
|||||
| engine | text | 2147483647 | null |
|
|
{“what”:“Engine name (e.g., ‘vega’, ‘plotly’) that produced the showcase.”,“why”:“Determines which build pipeline and output format to use; without it, the build cannot be reproduced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:54.716395595+00:00”} |
|||||
| status | text | 2147483647 | 'pending'::text |
|
|
{“what”:“Build lifecycle state, e.g. ‘pending’, ‘building’, ‘succeeded’, ‘failed’.”,“why”:“Without it, we cannot tell if a showcase is ready to link or if a rebuild is needed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:54.733102440+00:00”} |
|||||
| public_url | text | 2147483647 | √ | null |
|
|
{“what”:“Public URL where the built showcase is accessible; null until build succeeds.”,“why”:“Without it, there is no way to link to the showcase from the UI or share it.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:54.745513170+00:00”} |
||||
| build_log | text | 2147483647 | √ | null |
|
|
{“what”:“Full build log output, including errors and warnings.”,“why”:“Without it, debugging a failed build is impossible; the log is the only trace of what went wrong.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:54.797925055+00:00”} |
||||
| built_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp when the build completed successfully; null if not built.”,“why”:“Without it, we cannot know when the showcase was last updated or if it is stale.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:54.813418555+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| showcases_pkey | Primary key | Asc | id |
| showcases_dataset_version_id_engine_key | Must be unique | Asc/Asc | dataset_version_id + engine |
| showcases_version_idx | Performance | Asc | dataset_version_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| showcases_status_check | (status = ANY (ARRAY['pending'::text, 'building'::text, 'ready'::text, 'failed'::text, 'unknown'::text])) |
| showcases_engine_check | (engine = ANY (ARRAY['metabase'::text, 'evidence'::text, 'observable'::text, 'grid'::text])) |