Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('trend_snapshots_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each snapshot; auto-incremented.”,“why”:“Without it, snapshots cannot be uniquely referenced or linked to other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:34.296094786+00:00”} |
|
| overrepresented | text | 2147483647 | null |
|
|
{“what”:“Text field containing the palette name that is overrepresented in this snapshot.”,“why”:“Without it, the snapshot lacks the overrepresented palette, so trend comparisons are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:34.393129312+00:00”} |
||
| underrepresented | text | 2147483647 | null |
|
|
{“what”:“Text field containing the palette name that is underrepresented in this snapshot.”,“why”:“Without it, the snapshot lacks the underrepresented palette, so trend comparisons are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:34.415459074+00:00”} |
||
| total_palettes | int4 | 10 | √ | null |
|
|
{“what”:“Total number of palettes considered in this snapshot; integer count.”,“why”:“Without it, the sample size is unknown, so over/underrepresentation cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:34.434366948+00:00”} |
|
| created_at | text | 2147483647 | (now())::text |
|
|
{“what”:“Timestamp of snapshot creation as text, in the format produced by now()::text.”,“why”:“Without it, the temporal order of snapshots is unknown, so trends over time cannot be analyzed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:34.451266487+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| trend_snapshots_pkey | Primary key | Asc | id |