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