Database Properties
Database Type: PostgreSQL - 18.4 (Ubuntu 18.4-1.pgdg24.04+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| business_tag | 0 | 1 | 2 | Table | {“what”:“Associates a business with a tag label; one row per tag per business.”,“why”:“Enables tagging businesses for filtering, search, or grouping by category.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:31.648608525+00:00”} |
| brand_clean_content | 0 | 0 | 4 | Table | {“what”:“Cleaned markdown content per business, one row per brand content version.”,“why”:“Without it, cleaned content is lost and cannot be served or re-processed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:26.026494713+00:00”} |
| brand_assessments | 0 | 0 | 8 | Table | {“what”:“One brand assessment per business, with asset list and evaluation results.”,“why”:“Without it, past assessment results and model versions are lost, so comparisons over time are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:23.410772296+00:00”} |
| brand_presence | 0 | 0 | 7 | Table | {“what”:“Aggregated brand presence metrics for a business across physical and digital channels.”,“why”:“Provides a single snapshot of a business’s channel mix for comparison or scoring.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:33.892056063+00:00”} |
| brand_assets | 0 | 0 | 7 | Table | {“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”} |
| crawl_reachability | 0 | 0 | 6 | Table | |
| business_family | 0 | 0 | 2 | Table | |
| brand_nouns | 0 | 0 | 14 | Table | {“what”:“Records of brand-specific noun usage rules for a business.”,“why”:“Without it, brand terminology and grammar rules are unknown, causing inconsistent content.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.924278266+00:00”} |
| brand_profiles | 0 | 0 | 5 | Table | {“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”} |
| taxonomy_family | 1 | 0 | 2 | Table | {“what”:“Maps a short tag to a taxonomic family name.”,“why”:“Without it, family names have no stable identifier for joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:58.383461125+00:00”} |