palettes


Description

{“what”:“A set of color palettes, each with a unique id and metadata.”,“why”:“Without it, palette data cannot be persisted or retrieved, making the feature non-existent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:44.173524537+00:00”}

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”}

tags 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

Relationships