Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('trend_measurements_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for this measurement row.”,“why”:“Needed to reference, update, or delete a specific measurement.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:56.914598124+00:00”} |
|
| color_concordance | float4 | 8,8 | null |
|
|
{“what”:“Score of color harmony, higher means more concordant.”,“why”:“Without it, trends cannot be ranked by color consistency.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:56.932082066+00:00”} |
||
| spatial_structure | float4 | 8,8 | null |
|
|
{“what”:“Score of spatial organization strength in the trend.”,“why”:“Needed to evaluate how well elements are arranged.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:56.983714635+00:00”} |
||
| concept_specificity | float4 | 8,8 | null |
|
|
{“what”:“Score of how narrowly defined the trend’s concept is.”,“why”:“Distinguishes broad vs specific trends for filtering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:56.999314342+00:00”} |
||
| aesthetic_delta | float4 | 8,8 | null |
|
|
{“what”:“Change in aesthetic quality from a baseline.”,“why”:“Measures improvement or decline in visual appeal.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:57.048058917+00:00”} |
||
| weight | float4 | 8,8 | √ | 1.0 |
|
|
{“what”:“Multiplier applied to this measurement in aggregations.”,“why”:“Allows some measurements to influence results more than others.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:57.060454897+00:00”} |
|
| source | text | 2147483647 | √ | null |
|
|
{“what”:“Origin identifier or description of the measurement.”,“why”:“Traces provenance and enables filtering by data source.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:57.071356912+00:00”} |
|
| created_at | text | 2147483647 | (now())::text |
|
|
{“what”:“Timestamp of when the measurement was recorded, as text.”,“why”:“Needed for time-based analysis and ordering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:57.087876435+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| trend_measurements_pkey | Primary key | Asc | id |