brand_assessments

{“what”:“Unique numeric identifier for this assessment; internal primary key.”,“why”:“Without it, there is no stable way to reference a specific assessment in other tables or API responses.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:23.463342285+00:00”}

{“what”:“Identifier of the business being assessed; foreign key to business.id.”,“why”:“Without it, an assessment cannot be attributed to a business, so per-business history and filtering are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:23.492280949+00:00”}

{“what”:“JSON array of asset identifiers included in this assessment; empty array means none.”,“why”:“Without it, it is unknown which assets were evaluated, so results cannot be reproduced or compared.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:23.555739047+00:00”}

{“what”:“JSON object containing the evaluation output (scores, findings) for the assets.”,“why”:“Without it, the actual assessment outcome is missing, making the row useless for reporting or decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:23.570737527+00:00”}

{“what”:“Markdown-formatted human-readable summary of the assessment; empty string if none.”,“why”:“Without it, there is no quick human-readable overview, forcing readers to parse raw JSON.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:23.589241818+00:00”}

{“what”:“YAML-formatted metadata for the assessment run; empty string if none.”,“why”:“Without it, details about how the assessment was configured are lost, hindering reproducibility.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:23.600763438+00:00”}

{“what”:“Name or version of the model used to generate the assessment; empty if not recorded.”,“why”:“Without it, results cannot be traced to the model version, so changes in model behavior are undetectable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:23.643353888+00:00”}

{“what”:“Timestamp with time zone of when the assessment was created; defaults to current time.”,“why”:“Without it, the order and timing of assessments are unknown, so time-based analysis is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:23.701515385+00:00”}