module-spec · supabase_json
KnowledgeVault AI module-spec M-09
M-09 delivers the manager-facing company coverage dashboard — the primary value-proof surface for buyer retention. It creates company_dashboard_mv, a single-row-per-company materialized view (pg_cron refresh every 60 minutes) aggregating four data sections: a per-SKU coverage grid (red/yellow/green thresholds from products.coverage_pct via company_knowledge_access), top field queries ranked by frequency, a slang cloud of technician-searched terms with verification state, and platform ROI stats.
Open Questions
- OQ-M-09-01: id: string, owner: string, blocks: string, question: string, resolved: boolean, resolution: string
- OQ-M-09-02: id: string, owner: string, blocks: string, question: string, resolved: boolean, resolution: string
- OQ-M-09-03: id: string, owner: string, blocks: string, question: string, resolved: boolean, resolution: string
- OQ-M-09-04: id: string, owner: string, blocks: string, question: string, resolved: boolean, resolution: string