price_history

{“what”:“Unique integer identifier for each price record, generated from sequence.”,“why”:“Without it, duplicate rows are indistinguishable and cannot be referenced reliably.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:49.562339902+00:00”}

{“what”:“Type of the offering, e.g., ‘product’ or ‘service’, used with offering_id.”,“why”:“Without it, offering_id is ambiguous across different offering types, so the target offering cannot be identified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:49.596015692+00:00”}

{“what”:“Identifier of the offering whose price is recorded, scoped by offering_type.”,“why”:“Without it, the price cannot be linked to a specific offering, making the record meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:49.606998227+00:00”}

{“what”:“Kind of price, e.g., ‘list’, ‘sale’, ‘wholesale’.”,“why”:“Without it, price categories are indistinguishable, so queries for a specific price type return mixed data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:49.623247315+00:00”}

{“what”:“Price amount in US dollars, e.g., 19.99.”,“why”:“Without it, the actual price value is missing, so any price comparison or calculation is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:49.668812059+00:00”}

{“what”:“Timestamp when the price was recorded, with timezone, defaulting to current time.”,“why”:“Without it, the time of the price observation is unknown, so time-series analysis and ordering of records are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:49.678776914+00:00”}