Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| business_id | int8 | 19 | null |
|
|
{“what”:“Unique identifier of the business this presence profile belongs to.”,“why”:“Links each presence snapshot to a specific business; enables joins and lookups.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:34.017152228+00:00”} |
||
| physical_presence | int2 | 5 | √ | null |
|
|
{“what”:“Numeric score indicating physical footprint strength (e.g., store count).”,“why”:“Quantifies offline presence to compare against digital metrics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:34.065747704+00:00”} |
|
| digital_presence | int2 | 5 | √ | null |
|
|
{“what”:“Numeric score indicating digital footprint strength (e.g., online activity).”,“why”:“Quantifies online presence to compare against physical metrics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:34.094150216+00:00”} |
|
| digital_ratio | int2 | 5 | √ | null |
|
|
{“what”:“Percentage (0-100) of total presence attributed to digital channels.”,“why”:“Shows the balance between physical and digital for trend analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:34.233523979+00:00”} |
|
| digital_sales_dominance | int2 | 5 | √ | null |
|
|
{“what”:“Score indicating whether sales are dominated by digital channels (higher = more digital).”,“why”:“Helps classify businesses as digital-first or physical-first.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:34.286522801+00:00”} |
|
| signals | jsonb | 2147483647 | √ | null |
|
|
{“what”:“Flexible JSON payload with additional presence signals or raw data.”,“why”:“Captures extra metrics not covered by fixed columns without schema changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:34.371263585+00:00”} |
|
| computed_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when this presence snapshot was calculated.”,“why”:“Tracks data freshness and allows time-series analysis of presence changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:34.403392653+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| brand_presence_pkey | Primary key | Asc | business_id |