Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('feedback_records_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each feedback record.”,“why”:“Without it, rows cannot be uniquely referenced or joined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:56.864508274+00:00”} |
|
| recipe | text | 2147483647 | null |
|
|
{“what”:“Recipe identifier or description used to generate the design.”,“why”:“Without it, cannot trace which generation recipe produced the output.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:56.883591012+00:00”} |
||
| control_mode | text | 2147483647 | null |
|
|
{“what”:“Control mode used during generation, e.g., manual or automatic.”,“why”:“Without it, cannot distinguish feedback by generation control type.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:56.903379831+00:00”} |
||
| control_scale | float4 | 8,8 | null |
|
|
{“what”:“Numeric scale of control applied, unitless.”,“why”:“Without it, the intensity of control is unknown, affecting interpretation of metrics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:56.919919728+00:00”} |
||
| palette | text | 2147483647 | √ | null |
|
|
{“what”:“Color palette name or identifier used in generation.”,“why”:“Without it, cannot analyze feedback by palette choice.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:56.933220486+00:00”} |
|
| harmony | text | 2147483647 | √ | null |
|
|
{“what”:“Harmony rule or setting applied to the design.”,“why”:“Without it, harmony’s effect on feedback cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:56.943630656+00:00”} |
|
| prompt_hash | text | 2147483647 | √ | null |
|
|
{“what”:“Hash of the generation prompt, e.g., SHA-256.”,“why”:“Without it, cannot link feedback to exact prompt without storing full text.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:56.952697497+00:00”} |
|
| asset_type | text | 2147483647 | √ | null |
|
|
{“what”:“Type of generated asset, e.g., logo, icon, illustration.”,“why”:“Without it, feedback cannot be segmented by asset category.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:56.962376464+00:00”} |
|
| platform | text | 2147483647 | √ | null |
|
|
{“what”:“Target platform for the asset, e.g., web, mobile.”,“why”:“Without it, platform-specific feedback patterns are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:56.974313184+00:00”} |
|
| use_case | text | 2147483647 | √ | null |
|
|
{“what”:“Intended use case for the asset, e.g., branding, UI.”,“why”:“Without it, feedback context by use case is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:56.985653551+00:00”} |
|
| signal_strength | float4 | 8,8 | √ | null |
|
|
{“what”:“Signal strength metric value, unitless.”,“why”:“Without it, signal strength’s correlation with other metrics is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:57.001468945+00:00”} |
|
| color_concordance | float4 | 8,8 | √ | null |
|
|
{“what”:“Color concordance score, higher is better.”,“why”:“Without it, color harmony quality cannot be evaluated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:57.014727922+00:00”} |
|
| spatial_structure | float4 | 8,8 | √ | null |
|
|
{“what”:“Spatial structure score, higher is better.”,“why”:“Without it, layout quality cannot be measured.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:57.031596604+00:00”} |
|
| concept_specificity | float4 | 8,8 | √ | null |
|
|
{“what”:“Concept specificity score, higher is better.”,“why”:“Without it, how well the design matches the concept is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:57.058425543+00:00”} |
|
| aesthetic_delta | float4 | 8,8 | √ | null |
|
|
{“what”:“Change in aesthetic score from baseline, can be negative.”,“why”:“Without it, aesthetic improvement or regression is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:57.094717531+00:00”} |
|
| art_taste | float4 | 8,8 | √ | null |
|
|
{“what”:“Art taste score, higher is better.”,“why”:“Without it, artistic quality cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:57.112476855+00:00”} |
|
| design_taste | float4 | 8,8 | √ | null |
|
|
{“what”:“Design taste score, higher is better.”,“why”:“Without it, design quality cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:57.124871899+00:00”} |
|
| ux_taste | float4 | 8,8 | √ | null |
|
|
{“what”:“UX taste score, higher is better.”,“why”:“Without it, user experience quality cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:57.136207434+00:00”} |
|
| ux_composite | float4 | 8,8 | √ | null |
|
|
{“what”:“Composite UX score combining multiple UX metrics.”,“why”:“Without it, overall UX performance is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:57.151821289+00:00”} |
|
| novelty | float4 | 8,8 | √ | null |
|
|
{“what”:“Novelty score, higher is more original.”,“why”:“Without it, originality of the design is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:57.173597207+00:00”} |
|
| paradox_score | float4 | 8,8 | √ | null |
|
|
{“what”:“Paradox score measuring conflicting attributes, higher indicates more paradox.”,“why”:“Without it, paradoxical aspects of the design are unmeasured.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:57.187035371+00:00”} |
|
| generation_duration_ms | int4 | 10 | √ | null |
|
|
{“what”:“Time taken to generate the asset in milliseconds.”,“why”:“Without it, performance and efficiency of generation cannot be analyzed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:57.200794839+00:00”} |
|
| image_hash | text | 2147483647 | √ | null |
|
|
{“what”:“Hash of the generated image, e.g., perceptual hash.”,“why”:“Without it, cannot deduplicate or compare images.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:57.219517851+00:00”} |
|
| created_at | text | 2147483647 | (now())::text |
|
|
{“what”:“Creation timestamp in ISO 8601 format, e.g., 2025-01-01T00:00:00Z.”,“why”:“Without it, cannot order or filter feedback by time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:57.249548021+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| feedback_records_pkey | Primary key | Asc | id |
| idx_feedback_asset_type | Performance | Asc | asset_type |
| idx_feedback_recipe | Performance | Asc | recipe |
| idx_feedback_score | Performance | Desc | signal_strength |