Database Properties
Database Type: PostgreSQL - 18.4 (Ubuntu 18.4-1.pgdg24.04+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| style_fingerprints | 0 | 0 | 5 | Table | {“what”:“A registry of style fingerprints per collection and label.”,“why”:“Without it, style detection has no reference data to match against.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:05.311759211+00:00”} |
| corpus_images | 0 | 0 | 4 | Table | {“what”:“Image records in a corpus, each with a label and vector embedding.”,“why”:“Without it, there is no persistent store for image embeddings and labels, breaking similarity search and training.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:39.309226620+00:00”} |
| style_collections | 0 | 0 | 4 | Table | {“what”:“A named group of styles; each row is a distinct collection.”,“why”:“Without it, there is no way to refer to a set of styles as a single unit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:56.752633629+00:00”} |
| feedback_records | 0 | 0 | 24 | Table | |
| trend_measurements | 0 | 0 | 8 | Table | {“what”:“Central table for trend evaluation metrics.”,“why”:“Without it, trend metrics would be scattered and unqueryable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:56.899858623+00:00”} |
| palettes | 0 | 0 | 6 | Table | {“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”} |
| trend_snapshots | 0 | 0 | 5 | Table | {“what”:“Table containing snapshots of palette trend data.”,“why”:“Without it, there is no persistent record of palette trends, so historical comparisons cannot be made.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:34.276624346+00:00”} |