datasets


Description

{“what”:“A named collection of data records, each with a source kind and description.”,“why”:“Without it, there is no central registry of datasets, making it impossible to reference or manage them.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:33.978602484+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
dataset_versions.dataset_id dataset_versions_dataset_id_fkey C

{“what”:“Randomly generated UUID, the primary key for the dataset.”,“why”:“Without it, datasets cannot be uniquely referenced, breaking foreign keys and lookups.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:34.204504228+00:00”}

name text 2147483647 null

{“what”:“A required text label for the dataset, used for display and selection.”,“why”:“Without it, users cannot identify or select a dataset by name, and the dataset lacks a meaningful label.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:34.244315845+00:00”}

description text 2147483647 √ null

{“what”:“Optional free-form text describing the dataset’s contents or purpose.”,“why”:“Without it, the dataset’s context and intended use are unknown, making it hard to decide if it’s relevant.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:34.294503693+00:00”}

source_kind text 2147483647 null

{“what”:“A text label that distinguishes the origin of the dataset, used for filtering.”,“why”:“Without it, the dataset’s origin is unknown, making it impossible to apply source-specific processing or validation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:34.305631853+00:00”}

created_at timestamptz 35,6 now()

{“what”:“The exact moment the dataset was added, recorded as a timezone-aware timestamp.”,“why”:“Without it, the dataset’s age and ordering are unknown, making it impossible to track when data was added or to sort by creation time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:34.419605501+00:00”}

Indexes

Constraint Name Type Sort Column(s)
datasets_pkey Primary key Asc id
datasets_name_key Must be unique Asc name

Check Constraints

Constraint Name Constraint
datasets_source_kind_check (source_kind = ANY (ARRAY['upload'::text, 'pg_table'::text]))

Relationships