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 |