showcases


Description

{“what”:“One row per showcase build attempt for a dataset version.”,“why”:“Without it, we cannot know which dataset versions have a public showcase or whether a build succeeded.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:54.649511566+00:00”}

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
dataset_versions.id showcases_dataset_version_id_fkey C

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

Relationships