Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| business_id | int8 | 19 | null |
|
|
{“what”:“Identifier of the business, matches business table’s primary key.”,“why”:“Without it, profiles cannot be linked to a specific business.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:53.149527178+00:00”} |
||
| assessment | jsonb | 2147483647 | '{}'::jsonb |
|
|
{“what”:“JSON object with assessment results; empty object when none.”,“why”:“Without it, assessment data is unavailable for display or analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:53.173556673+00:00”} |
||
| summary_md | text | 2147483647 | ''::text |
|
|
{“what”:“Markdown text of the profile summary; empty string when not generated.”,“why”:“Without it, the human-readable summary is missing from the profile.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:53.188616030+00:00”} |
||
| meta_yaml | text | 2147483647 | ''::text |
|
|
{“what”:“YAML text containing profile metadata; empty string when absent.”,“why”:“Without it, metadata such as version or source is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:53.214091855+00:00”} |
||
| updated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of last update to this row; timezone-aware.”,“why”:“Without it, staleness of profile cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:53.257938210+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| brand_profiles_pkey | Primary key | Asc | business_id |