taxonomy_family


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
tag text 2147483647 null
business_tag.tag Implied Constraint R

{“what”:“Unique short code, e.g., ‘Fabaceae’; primary key for the family.”,“why”:“Provides a stable key to reference families from other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:58.402492391+00:00”}

family text 2147483647 null

{“what”:“Full taxonomic family name, e.g., ‘Leguminosae’.”,“why”:“Human-readable label; without it, tags are opaque.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:58.435987284+00:00”}

Indexes

Constraint Name Type Sort Column(s)
taxonomy_family_pkey Primary key Asc tag

Relationships