brand_profiles


Description

{“what”:“One row per business, holding its assessment, summary, and metadata.”,“why”:“Without it, per-business profile data has no canonical home.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:53.135477935+00:00”}

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

Relationships