brand_assets


Description

{“what”:“Brand-related content (e.g., markdown) and its source metadata for a business.”,“why”:“Without it, brand assets cannot be scoped to a business, so retrieval for a specific business is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:36.884165847+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('brand_assets_id_seq'::regclass)

{“what”:“Auto-incrementing integer that uniquely identifies a brand asset.”,“why”:“Without it, rows cannot be referenced by foreign keys or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:36.930856157+00:00”}

business_id int8 19 null

{“what”:“Numeric ID of the owning business; references a business record.”,“why”:“Without it, assets cannot be scoped to a business, so queries for a business’s assets are ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:36.987711325+00:00”}

source text 2147483647 null

{“what”:“Text describing where the asset came from, such as a provider name.”,“why”:“Without it, the provenance of the asset is unknown, making audits or re-fetching impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:37.021383558+00:00”}

source_url text 2147483647 ''::text

{“what”:“URL from which the asset was fetched; empty if not applicable.”,“why”:“Without it, the original location is lost, so updates or re-imports cannot be performed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:37.162000285+00:00”}

asset_type text 2147483647 'markdown'::text

{“what”:“Content format of the asset, defaulting to ‘markdown’.”,“why”:“Without it, the rendering or processing logic cannot choose the correct parser.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:37.235327886+00:00”}

raw_md text 2147483647 ''::text

{“what”:“Raw markdown text of the asset; empty for non-markdown types.”,“why”:“Without it, the asset’s content is unavailable, so it cannot be rendered or displayed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:37.267021150+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp with time zone when the row was created.”,“why”:“Without it, the age of the asset is unknown, so audit or ordering by creation time is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:37.298414552+00:00”}

Indexes

Constraint Name Type Sort Column(s)
brand_assets_pkey Primary key Asc id
idx_assets_business Performance Asc business_id

Relationships