Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('palettes_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each palette, auto-incremented.”,“why”:“Without it, palettes cannot be uniquely referenced or linked to other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:44.218526086+00:00”} |
|
| source | text | 2147483647 | null |
|
|
{“what”:“Origin of the palette, e.g., website name or user handle.”,“why”:“Without it, the provenance of each palette is unknown, making it impossible to attribute or filter by source.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:44.230703829+00:00”} |
||
| colors | text | 2147483647 | null |
|
|
{“what”:“List of color codes, likely hex values, separated by a delimiter.”,“why”:“Without it, the palette has no actual color data, making the record useless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:44.245238902+00:00”} |
||
| text | 2147483647 | √ | null |
|
|
{“what”:“Comma-separated tags for categorization, e.g., ‘sunset, pastel’.”,“why”:“Without it, palettes cannot be grouped or searched by theme, reducing discoverability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:44.260407547+00:00”} |
||
| popularity | int4 | 10 | √ | 0 |
|
|
{“what”:“Numeric popularity score, higher means more used or liked.”,“why”:“Without it, there is no way to rank or sort palettes by user engagement.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:44.282711104+00:00”} |
|
| ingested_at | text | 2147483647 | (now())::text |
|
|
{“what”:“Timestamp of when the palette was added, stored as text in ISO format.”,“why”:“Without it, the recency of each palette is unknown, preventing time-based filtering or ordering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:44.307554872+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| palettes_pkey | Primary key | Asc | id |
| idx_palettes_source | Performance | Asc | source |