Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('corpus_images_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each image record; primary key.”,“why”:“Without it, rows cannot be uniquely referenced, breaking joins, updates, and deletes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:39.629145872+00:00”} |
|
| label | text | 2147483647 | null |
|
|
{“what”:“Text label or category assigned to the image, such as ‘cat’ or ‘dog’.”,“why”:“Without it, the image’s category is unknown, so classification or filtering by label fails.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:39.972342234+00:00”} |
||
| embedding | bytea | 2147483647 | null |
|
|
{“what”:“Binary serialized vector embedding of the image, typically a float array.”,“why”:“Without it, image similarity or retrieval cannot be computed, breaking search and clustering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:39.996114887+00:00”} |
||
| added_at | text | 2147483647 | (now())::text |
|
|
{“what”:“Insertion timestamp as text, e.g., ‘2025-01-01 12:00:00.123456’.”,“why”:“Without it, the age of the image record is unknown, making audit or ordering by insertion time impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:40.028332019+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| corpus_images_pkey | Primary key | Asc | id |