Tables


SchemaSpy Analysis of brandrhythm.public

Generated on Tue Sep 22 22:50 PDT 2026

XML Representation
Insertion Order Deletion Order
TABLES 10
VIEWS 0
COLUMNS 57
Constraints 0
Anomalies 3
Routines 0

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”}