feedback_records


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

Relationships