Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('brand_clean_content_id_seq'::regclass) |
|
|
{“what”:“Surrogate primary key, auto-incrementing bigint sequence value.”,“why”:“Uniquely identifies each content row for updates and joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:26.062628979+00:00”} |
|
| business_id | int8 | 19 | null |
|
|
{“what”:“Foreign key to the owning business; not null.”,“why”:“Associates content to a specific business; missing it orphans the row.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:26.110542895+00:00”} |
||
| clean_md | text | 2147483647 | null |
|
|
{“what”:“Full cleaned content in Markdown format, not null.”,“why”:“Holds the actual cleaned text; without it no content is available.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:26.150184939+00:00”} |
||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp with time zone when the row was inserted, defaults to now().”,“why”:“Records content version time for audit and ordering; missing it loses history.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:26.164169420+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| brand_clean_content_pkey | Primary key | Asc | id |
| brand_clean_content_business_id_key | Must be unique | Asc | business_id |