brand_nouns


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('brand_nouns_id_seq'::regclass)

{“what”:“Unique numeric identifier for each brand noun record.”,“why”:“Without it, records cannot be referenced or updated uniquely.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.977120691+00:00”}

business_id int8 19 null

{“what”:“Identifier of the business this noun rule belongs to.”,“why”:“Without it, rules cannot be scoped to a specific business, causing cross-brand conflicts.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:34.004786477+00:00”}

term text 2147483647 null

{“what”:“The exact noun phrase, e.g., ‘iPhone’ or ‘AirPods’.”,“why”:“Without it, there is no key to look up the rule for a given term.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:34.018657064+00:00”}

noun_type text 2147483647 null

{“what”:“Category of the noun, e.g., ‘product’ or ‘feature’.”,“why”:“Without it, rules cannot be filtered by type, making it hard to apply context-specific grammar.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:34.047038728+00:00”}

head_noun text 2147483647 √ null

{“what”:“The core noun within the term, e.g., ‘Phone’ for ‘iPhone’.”,“why”:“Without it, grammatical agreement (e.g., article choice) cannot be determined for compound terms.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:34.067511343+00:00”}

definition text 2147483647 √ null

{“what”:“Plain-language meaning of the term.”,“why”:“Without it, writers cannot understand what the term refers to, risking misuse.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:34.085801598+00:00”}

article_rule text 2147483647 √ null

{“what”:“Rule for article selection, e.g., ‘a’ or ‘an’ based on pronunciation.”,“why”:“Without it, article usage becomes inconsistent, breaking natural language output.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:34.134997462+00:00”}

correct_usage_template text 2147483647 √ null

{“what”:“Template showing correct sentence structure using the term.”,“why”:“Without it, there is no reference for correct grammar, leading to errors.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:34.192038759+00:00”}

incorrect_forms _text 2147483647 √ null

{“what”:“List of common incorrect forms of the term.”,“why”:“Without it, there is no way to flag or correct misuse in content.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:34.218812582+00:00”}

example_correct text 2147483647 √ null

{“what”:“Example sentence demonstrating correct usage.”,“why”:“Without it, writers lack a concrete model for correct usage.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:34.240851567+00:00”}

example_incorrect text 2147483647 √ null

{“what”:“Example sentence showing incorrect usage.”,“why”:“Without it, common mistakes are not illustrated, so they may persist.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:34.263590903+00:00”}

source text 2147483647 √ 'crawl'::text

{“what”:“Origin of the rule, e.g., ‘crawl’ or ‘manual’.”,“why”:“Without it, provenance is unknown, making it hard to assess reliability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:34.286720302+00:00”}

confidence float4 8,8 √ 0.5

{“what”:“Confidence score from 0 to 1 for the rule’s accuracy.”,“why”:“Without it, low-quality rules cannot be filtered out, risking incorrect grammar.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:34.299581560+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when the rule was created.”,“why”:“Without it, there is no audit trail or ability to sort by recency.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:34.347881554+00:00”}

Indexes

Constraint Name Type Sort Column(s)
brand_nouns_pkey Primary key Asc id
brand_nouns_business_id_term_key Must be unique Asc/Asc business_id + term
idx_brand_nouns_biz Performance Asc business_id
idx_brand_nouns_business Performance Asc business_id
idx_brand_nouns_type Performance Asc noun_type

Relationships