dataset_versions


Description

{“what”:“A versioned snapshot of a dataset’s schema, row count, and storage location.”,“why”:“Without it, dataset changes are untracked and historical states cannot be retrieved or compared.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:05.127144193+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
chart_specs.dataset_version_id chart_specs_dataset_version_id_fkey C
showcases.dataset_version_id showcases_dataset_version_id_fkey C

{“what”:“Randomly generated UUID that uniquely identifies this version row.”,“why”:“Without it, version rows cannot be uniquely referenced from other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:05.155037854+00:00”}

dataset_id uuid 2147483647 null
datasets.id dataset_versions_dataset_id_fkey C

{“what”:“Foreign key to the dataset table, identifying the parent dataset.”,“why”:“Without it, a version cannot be associated with its dataset, making it impossible to list versions per dataset.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:05.224687631+00:00”}

version int4 10 null

{“what”:“Integer version number, unique per dataset_id, used to order snapshots.”,“why”:“Without it, multiple snapshots of the same dataset are indistinguishable and cannot be ordered.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:05.258845668+00:00”}

row_count int8 19 0

{“what”:“Number of rows in the dataset at this version, as a bigint.”,“why”:“Without it, consumers cannot estimate dataset size or validate data completeness without loading the data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:05.319151179+00:00”}

column_spec jsonb 2147483647 '[]'::jsonb

{“what”:“JSON array describing the columns, e.g., names and types, for this version.”,“why”:“Without it, the schema of the dataset at this version is unknown, breaking schema evolution tracking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:05.382205630+00:00”}

storage_ref text 2147483647 null

{“what”:“Reference to the physical storage location of the dataset data, e.g., a file path or object key.”,“why”:“Without it, the actual data for this version cannot be located or retrieved.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:05.560759387+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when this version was created, in UTC with time zone.”,“why”:“Without it, the chronological order of versions is unknown, and audit trails are incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:05.669276497+00:00”}

Indexes

Constraint Name Type Sort Column(s)
dataset_versions_pkey Primary key Asc id
dataset_versions_dataset_id_version_key Must be unique Asc/Asc dataset_id + version

Relationships