Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
{“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 |
|
|
{“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 |