business_tag


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
business_id int8 19 √ null

{“what”:“Bigint foreign key referencing the business being tagged.”,“why”:“Links each tag to a specific business; without it tags are unattached.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:31.757807657+00:00”}

tag text 2147483647 √ null
taxonomy_family.tag Implied Constraint R

{“what”:“Free-text label such as ‘vegan’ or ‘24h’; used for categorization.”,“why”:“Provides the tag value; without it no category or filter can be applied.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:31.803252632+00:00”}

Relationships