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 |